Designing a Database

Task: Designing a Database

Choose any organization and design a database for that this organization by following the format given below. Some suggestions are bank, university, school, hospital, library, football club, car sales company, bookstore etc.

A. Summary

• The summary is an abstract that gives a broad picture of the contents of the report.

• It should not start off by “In this report you are going to….” This summary should be one page.

• It should summarize the report to the extent that if this is the only page the reader reads, he/she will know what is in the full report.

B. Company & Product Description

• Give a background of the chosen company.

• Describe briefly what you are going to do for this company. Here, you will list the tables you are going to make with their columns and primary keys. You must make at least five tables.

C. Entity-Relationship Diagram

• Make an ER Diagram to show entities, attributes and relationships between all the tables.

• Write a paragraph to describe your ER Diagram.

D. Normalization

• In this section, show the tables with some data – at least five rows.

• Make sure all the tables are normalized up to 3 NF (no multivalued attributes, no partial and transitive dependencies).

• If you need to make new tables to do normalization, you can show the new tables in this section.

E. Relational Algebra

• Perform all eight relational algebra operations on any of your tables and show the output.

F. Member Contribution & Conclusions

• Clearly describe how each member contributed towards achieving the project’s objectives including tasks and roles

Evner: Database Administration

Se mere: task five, sales with company car, sales roles, sales administration, product design in hospital, product database design, how to write company background, how to write a summary report, how to write a company background, how to write a background of a company, how to design a car, how do you write a report, how can one write a report, designing a picture, contents of product description, contents of a write up, c&f bank, c and f bank, background of a company, abstract summary format

Om arbejdsgiveren:
( 0 bedømmelser ) Jeddah, Saudi Arabia

Projekt ID: #1583034

3 freelancere byder i gennemsnit $175 på dette job


check ur pm.

$250 USD på 1 dag
(0 bedømmelser)

hi i can do it precisely if you give me the chance ...thanks

$175 USD in 2 dage
(0 bedømmelser)

This is a simple project for me. have a look on the attachment.

$100 USD in 3 dage
(0 bedømmelser)