Transcription of ER & EER to Relational Mapping
{{id}} {{{paragraph}}}
Example: air traffic controller
ER & EER to Relational Mapping
ER & EER to Relational Mapping Chapter 9 1. Figure ER schema diagram for the company database. Fname Minit Lname Number N 1. Address Locations Name WORKS_FOR Name Sex Salary Ssn ___. NumberOfEmployees DEPARTMENT. StartDate EMPLOYEE. Bdate 1 1 1. MANAGES. CONTROLS. N. Hours supervisor supervisee N. WORKS_ON PROJECT. 1 SUPERVISION N 1. Name Location Number _____. DEPENDENTS_OF. N. DEPENDENT. Name Sex BirthDate Relationship Addison Wesley Longman, Inc. 2000, Elmasri/Navathe, Fundamentals of Database Systems, Third Edition Step 1: For each regular entity type E. Create a relation R that includes all the simple attributes of E.
relationship into a relational schema you must use one of the four options available. Let C be the super-class, K its primary key and A. 1, A. 2, …, A. n. its remaining attributes and let S. 1, S. 2, …, S. m. be the sub-classes. Chapter 9 11. Option 8A (multiple relation option):
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: