Identify at least one candidate key

Assignment Help Database Management System

Reference no: EM132081281

You need the specific answers for these questions, and clear vision diagram

Consider the following tables:

GENRE(GEN_CODE, GEN_DESCRIPTION)

BOOK(BOOK_ISBN, BOOK_TITLE, BOOK_PRICE, GEN_CODE)

For the tables given above, work on the problems below:

1. For each table, identify the primary key.

2. For each table, identify the foreign key(s).

3. Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key.

4. For one of the tables, give examples of a superkey and a secondary key.

5. For the given tables, explain how entity integrity and referential integrity could be violated. Give specific examples.

6. Use Visio to create a detailed Crow's Foot ERD. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.

Reference no: EM132081281

Questions Cloud

Write an rsa encryption-decryption program : You need an RSA encryption/decryption program in c or c++. The program just needs to be able to generate public/private keys and also encrypt/decrypt.

Purchasing an australian government bond : An investor purchasing an Australian Government Bond is entitled to receive annual payments from the Australian government forever

Determine necessary consideration for building your program : Displays a list of animal/habitat options (based on the previous selection) as read from either the animals or habitats file.

Share of common stock be selling for in the market : The company has a dividend payout ratio of 50%, book value per share of $33.5 and a P/E ratio of 15. What should one share of common stock

Identify at least one candidate key : Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key.

What is the value of company : If the cost of capital is 10%, what is the value of this company?

Write a program that finds the smallest word and largest : Write a program that prompts for your first name and then last name. Enter them respectively and make your full name and output it.

The art of cinematography : To create an effective designed, the director, cinematographer, and production designer need to work together

What is the company current stock price : The company's beta is 1.65, the market risk premium is 8.5%, and the risk-free rate is 5.50%. What is the company's current stock price?

User Account

All Pages