Transform the logical E-R diagram of Figure 1 into a physical E-R diagram. The s

Question

Transform the logical E-R diagram of Figure 1 into a physical E-R diagram. The sizes of the attributes of each table and the expected initial record counts per table are shown in table 1. Perform a volumetrics analysis for the database. Assume that the DBMS that will be used to implement the system requires 30% overhead to be factored into the estimates. Also, assume a growth rate of 10% for the database per year. The systems development team wants to ensure that adequate data storage is obtained for the next 3 years.

offering Student StdSSN OfferNo StdName Of Location Registers Enrollment Grants EnrGrade Figure 1 Student Enrollment System Volumetrics Analysis Attributes Record Overhead Tota nitial Table Initial Table Name/Attributes Sizes Size Factor Record Size (records) Table Volume Size 2,000 Student StdSSN StdName. 50 30% Offering 500 Offer No Offer Location 30% 6000 Enrollment ForeignKey Foreign Key2 EnrGrade 30% Total Initial Volume: Growth Rate per Year: 10% Total Volume in 3 years Table 1

Explanation / Answer

transform the logical E-R diagram of discern 1 right into a bodily E-R diagram. The sizes of the attributes of each desk and the expected initial document counts in line with table are shown in table 1. perform a volumetrics analysis for the database. count on that the DBMS so one can be used to put in force the device requires 30% overhead to be factored into the estimates. also, count on a growth price of 10% for the database according to yr. The systems development crew wants to make certain that ok statistics storage is received for the subsequent 3 years.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.