A Project

You are given a set of requirements for a university database. Based on the set of requirements for the university database, you are asked to do the following: 1. Partition the sentences (database requirement description in natural language) into homogeneous groups. (10 point) 2 Design the conceptual schema of the university database by using ER diagram and CSDL. (Please see the reference book 1, page 42-43). Your conceptual design of the database should include the followings but not limit to: a. Entities b. Relationships c. Keys d. Structural constraints (Cardinality ratio and participation constraints) (40 point) 3. Transform the ER schema of database you get from step 2 into the corresponding relational database schema. (20 point) a. specify all the key attributes of relations and any referential integrity constraints. b. specify the data item format for each attribute in each relation schema. c. specify all the functional dependencies you could infer from the requirements. 4. List all the join paths existing in the relational database schema you get from the transformation in step 3. (10 point) 5. Normalize relation schema in the database design that you get from step 4 into either 3NF or BCNF if it is necessary. (20 point) 6. Implement the relational database you get in step 5, via ORACLE SQL*PLUS, this includes creating the database, creating the corresponding relation schemas, data preparation and loading data into the database. (50 point) 7. Implement the given queries in ORACLE SQL*PLUS. (150 point) 8. Write a detailed and comprehensive report the database design and implementation.