Find Jobs
Hire Freelancers

CS Database Project Assignment

$30-100 USD

Cancelled
Posted over 9 years ago

$30-100 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.
Project ID: 6233859

About the project

Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of INDIA
India
0.0
0
Member since Jul 24, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.