Describe the logical database design

Assignment Help Database Management System

Reference no: EM131476522

Question: Part II: Report on Logical Database Design Good DBAs must be able to prepare a full design report. You should hand in the full, legible report (hopefully typeset) with a cover page that gives your name, the title of the project, and its brief description. The final report should include sufficient detail to describe all steps of your design:

(1) Describe what you have chosen as your database.

(2) List at least 10 reasonable queries in English.

(3) Add one or more atomic transactions to your query set.

(4) State assumptions about the database as briefly as possible.

(5) Give the ER diagram of the database.

(6) Give the relational database schema.

(7) (Up to 5 extra points) For each relation schema, give the associated FDs and specify the normal forms the schema satisfies.

(8) (Up to 5 extra points) Perform the decomposition into 3NF or BCNF and give the final database schema along with the FDs.

(9) Give the relational algebra expressions for the queries formulated in step 2.

(10)Give at least two reasonable, but unanswerable queries, and explain why the database cannot support them.

(11)In conclusion, describe what you have learned from the project, and include your observations about the power of relational systems and languages.

Reference no: EM131476522

Questions Cloud

Write a c function named days that determines number of days : Write a C function named days() that determines the number of days from the date 1/1/1900 for any date passed as a structure.

Successful company showing results in the market : Recommendation of how to turn BlackBerry around from a failing company to a successful company showing results in the market

What specific gender issue does the article center around : What gender issue is being discussed? Masculinity? Femininity? Bi-sexuality? Transgender Identities?What specific gender issue does the article center around?

Studying business strategy : Suppose a friend of yours was seeking to have a new house built by one of 2 local builders. Knowing that you are studying business strategy

Describe the logical database design : Report on Logical Database Design Good DBAs must be able to prepare a full design report. You should hand in the full, legible report (hopefully typeset).

Research two cultures different from your own : To prepare for this Discussion, research two cultures different from your own and compare their perspectives on aging to that of your own culture

East coast facility and distribution center westward : Keep the current setup, continue shipping products from the East Coast facility and distribution center westward;

Write an assignment on any topic related to business : Write an assignment on any topic related to business. Choose any topic like the importance of communication at the workplace with references

Discuss about the spiritual development : Spirituality, which may or may not include involvement with an established religion, contributes to human diversity and influences human behavior.

User Account

All Pages