## Answered: - Transform the logical E-R diagram of Figure 1 into a physical E-R

Deliverables:

Complete table 1 in Excel (i.e. complete the cell with question marks).? Use Excel formula to make any calculation and save the worksheet

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.

Student

Offering

StdSSN

StdName

OfferNo

OffLocation

Registers

Enrollment

Grants

Figure 1

Student Enrollment System

Volumetrics Analysis

Table

Name/Attributes

Student

StdSSN

StdName

sizes

Size

Factor

2,000

??

500

??

6000

30%

??

??

6

4

??

Enrollment

ForeignKey1 ??

ForeignKey2 ??

Initial Table Initial Table

Size (records) Volume

9

50

??

Offering

OfferNo

OfferLocation

Total

Record

Size

30%

??

??

??

3

??

30%

??

Total Initial Volume:

Growth Rate per Year:

Total Volume in 3 years:

??

10%

??

Table 1

Deliverables:

1. Complete table 1 in Excel (i.e. complete the cell with question marks). Use Excel formula to

make any calculation and save the worksheet

1

Criteria

Identification of the foreign keys with their sizes

Calculation of record sizes of the tables

Calculation of total record sizes of the tables

Calculation of initial table volumes

Calculation of total initial volume

Calculation of total volume in 3 years

Total

Points

3.0

1.5

1.5

1.5

1.0

1.5

10

2

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Oct 07, 2020

Solution~0002232832.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Oct 07, 2020

EXPERT

Tutor