Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Small College wants to migrate their data to a database system and your job is to help them design the new database. As first step,
Small College wants to migrate their data to a database system and your job is to help them design the new database. As first step, please begin the conceptual design by doing the following:
a. Identify all the entity types.
b. For each entity type, identify all the attributes. Note that some of the attributes may be
composite, multivalued, or derived.
c. Note any assumptions made during the design.
d. Using ERDPlus (www.erdplus.com), draw the initial ER diagram for this preliminary design
PAYROLL SYSTEM FILES Faculty.file ID Nr Name Address Salary YTD earn Dpt. N 52,500 59,000 60,000 119Marten, Ann 94 Ridge, Grant, MI 209 Newton, Jane 210 Leonard, Ada, MI 421 Johns, Alice 121 Calhoun, Hart, MI 462 Johnson, Tom 604 46th Street, Lowell, MI65,000 485 Sparks, Pam201 Olive, Holt, MI 507 Canton, Rob5 State, Cutler, MI 564 Ferris, Gina16 W.9th St., Troy, MI 683 Nils, Frank46 Creston, Ada, MI 15,425 18,945 11,402 16,952 20,115 11,010 18,450 22,050 43,500 59,500 58,500 76,500 Department.filc Dept. Nr Dept. Name Dept. Address Chair Computer Science 408 Kelly Hl Jones, Ann Mathematics Geology Physics 253 Watson Ha Sparks, Pam 707 Case TowerFerris, Gina 118 Font TowerNils, Frank
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started