csc4402_2011_home3 - Copy

csc4402_2011_home3 - Copy - CSC4402 Homework 3 Due Monday...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

csc4402_2011_home3 - Copy - CSC4402 Homework 3 Due Monday...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online