Database ERD & SQL plus
$30-250 USD
Paid on delivery
1- A fully annotated E-R diagram 1 and 2 showing the entities, primary and foreign keys, composite keys, relationships and optionality.
2- A relational schema of the database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys and which attributes are nullable, giving reasons. List any assumptions you need to make.
3- Listings of the records in each table. There should be at least 10 records in each.
4- Ensure consistency of data in the database by developing integrity and referential integrity constraints that will ensure the correctness of the data when it is entered.
5- Produce SQL listings on the specific questions based on the Case Study.
6- Documentation must be logically organised with clarity and completeness.
Project ID: #4776152
About the project
Awarded to:
13 freelancers are bidding on average $170 for this job
Hi I have more than 10 years experience in Database design and administration. Please see PM. Thanks.
When do you need this assignment by? Please send me a copy of the Case Study so we can make sure the ERD and DB we build meets its needs. Let's get started on this now so you don't have to worry about it tomorrow.
Hi i have 4+ years experience in database modeling, i can handle your work contact me for more information.
Hello, it would be a great pleasure for me to accomplish your task. I have worked 5,5 years as a software developer in the Bank and for 1 year at the University, where I trained students to do that.