ASSIGNMENT
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. 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 |
|
|
