CS Database Project Assignment - Repost - open to bidding
$30-250 USD
Closed
Posted about 9 years ago
$30-250 USD
Paid on delivery
**NOTE: Please see attached file for full description of project**
In this project option, you are asked to design and implement a database for a real miniworld
environment based on the given database requirements written in natural languages.
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.
Hello, I have completed Diploma in HRM and Bachelor in Business administration from Australia while my Master degree is in international Business from Finland. I have completed more than 140 projects . You may read the reviews in my profile. I shall deliver you excellent quality work. Please hire me. Regards
Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself -
Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !!
Looking forward to hear from you soon - GOD Bless You.