Read chapters 2 and 3 textbook and review reputable IGU online library resources and journals and discuss advantages and disadvantages of relational model.

Relational Model

1 Read chapters 2 and 3 textbook and review reputable IGU online library resources and journals and discuss: Advantages and Disadvantages of Relational Model.

2 Read chapter 3 and reputable journals/articles and IGU online library resources and describe the following relational operators: Union, Project, Intersect and Join. Please provide a real-world application example for each of these operators.

3 Read chapter 3 of textbook and review reputable IGU online library resources and journals and discuss:

What does it mean to say that a database displays both entity integrity and referential integrity? And why entity integrity and referential integrity important in a database? Provide an application example to support your discussion.

100 points

Type your answers on this document and submit this document.

1. Suppose that you are using the Database composed of the two tables shown in the following   figure.  Use these tables to answer part A,B,C (40  points)

Theater Database Tables

Identify the primary keys for each table. ( 15 points )

Identify the foreign key. ( 15 points )

What is the relationship between these 2 tables? (10 points)

Use the following Tables  to answer questions A-C . ( 60 Total points )

PRODUCT and vendor Database Tables

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space. ( 20 points )

TABLE PRIMARY KEY FOREIGN KEY(S)
PRODUCT

 

   

 

 

 

VENDOR    

Do the tables exhibit entity integrity? Answer Yes or No,  and then explain your answer. ( 20 points )

TABLE ENTITY INTEGRITY?

Type Yes or No here

EXPLANATION

Explain the reason here

PRODUCT    

 

 

 

 

 

VENDOR    

 

 

 

 

 

Do the tables exhibit referential integrity? Answer Yes or No, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. ( 20 points )

TABLE REFERENTIAL INTEGRITY EXPLANATION
PRODUCT    

 

 

 

 

VENDOR  

 

 

 

 

 

 

 

 

Read chapters 2 and 3 textbook and review reputable IGU online library resources and journals and discuss advantages and disadvantages of relational model.
Scroll to top