This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 2NF and there are no transitive dependencies. Problems: 4a. Use the STUDENT table structure shown in Table P6.4 do the following: a. Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies. Relational Schema: STUDENT ( STU_NUM , STU_LNAME, STU_MAJOR, STU_GPA, STU_HOURS, STU_CLASS) DEPARTMENT ( DEPT_CODE , DEPT_NAME, DEPT_PHONE) COLLEGE ( COLLEGE_NAME , ADVISOR_LNAME, ADVISOR_OFFICE, ADVISOR_BLDG, ADVISOR_PHONE) Dependency Diagram: Table Name: STUDENT Table Name: DEPARTMENT Table Name: COLLEGE...
View Full Document
- Summer '08
- Relational model, Database normalization, Surrogate key, dependency diagram