This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: CSC4402 Homework 3 Due Monday 9-26-2011 The following is the schema for a database about a company and its employees, projects, training courses offered, employee’s participation in the projects, and course enrollments (the primary key attributes are underlined ): CM (Company) (DIVISION DEPT BUDGET) EM (Employee, his home city, and the department to which he belongs) ( ID NAME CITY PHONE DEPT SALARY) PR (Project, project director, the location of the project, and the department conducting the project) ( Pnum DIRECTOR_ID CITY DEPT) EP (Employees in Project) ( Pnum ID HOUR) CR (Course offered) ( Cnum CNAME TEACHER_ID) ER (Enrollment) ( Cnum ID GRADE) The data type for BUDGET, GRADE, HOUR and SALARY is INTEGER, all other attributes have data type VARCHAR(30). Each department has one or more employees and conducts zero or more projects. An employee can take zero or more courses and work in zero or more projects (including the projects con- ducted by other department). Each project has one or more employees working on it, and each course hasducted by other department)....
View Full Document
This note was uploaded on 10/02/2011 for the course CS cs4402 taught by Professor Jianhua during the Fall '11 term at LSU.
- Fall '11