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

Please see attached file.?

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

 

 

EnrGrade

 

 

Figure 1

 

 

Student Enrollment System

 

Volumetrics Analysis

 

Table

 

Name/Attributes

 

Student

 

StdSSN

 

StdName

 

 

Attributes Record Overhead

 

sizes

 

Size

 

Factor

 

 

2,000

 

 

??

 

 

500

 

 

??

 

 

6000

 

 

30%

 

 

??

 

 

??

 

 

6

 

4

 

??

 

 

Enrollment

 

ForeignKey1 ??

 

ForeignKey2 ??

 

EnrGrade

 

 

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

 

Grading Rubric:

 

 

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:

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Oct 07, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.