Bundle: Database Systems Design, Implementation, & Management, Loose-leaf Version, 13th + MindTapV2.0, 1 term Printed Access Card
13th Edition
ISBN: 9780357475188
Author: Coronel, Carlos, Morris, Steven
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 2P
Program Plan Intro
Entity Integrity:
Entity Integrity is a
- The primary key of one database table row must not match the primary key of any other row present in the table.
- No component of primary key must be null.
Given database tables:
Table Name: EMPLOYEE
| EMP_CODE | EMP_TITLE | EMP_LNAME | EMP_FNAME | EMP_INITIAL | EMP_DOB | STORE_CODE |
| 1 | Mr. | Williamson | John | W | 21-May-84 | 3 |
| 2 | Ms. | Ratula | Nancy | 09-Feb-89 | 2 | |
| 3 | Ms. | Greenboro | Lottie | R | 02-Oct-81 | 4 |
| 4 | Mrs. | Rumpersfro | Jennie | S | 01-Jun-71 | 5 |
| 5 | Mr. | Smith | Robert | L | 23-Nov-59 | 3 |
| 6 | Mr. | Renselear | Cary | A | 25-Dec-85 | 1 |
| 7 | Mr. | Ogallo | Roberto | S | 31-Jul-82 | 3 |
| 8 | Ms. | Johnson | Elizabeth | I | 10-Sep-88 | 1 |
| 9 | Mr. | Eindsmar | Jack | W | 19-Apr-55 | 2 |
| 10 | Mrs. | Jones | Rose | R | 06-Mar-66 | 4 |
| 11 | Mr. | Broderick | Tom | 21-Oct-72 | 3 | |
| 12 | Mr. | Washington | Alan | Y | 08-Sept-74 | 2 |
| 13 | Mr. | Smith | Peter | N | 25-Aug-64 | 3 |
| 14 | Ms. | Smith | Sherry | H | 25-May-66 | 4 |
| 15 | Mr. | Olenko | Howard | U | 24-May-64 | 5 |
| 16 | Mr. | Archialo | Barry | V | 03-Sep-60 | 5 |
| 17 | Ms. | Grimaldo | Jeanine | K | 12-Nov-70 | 4 |
| 18 | Mr. | Rosenburg | Andrew | D | 24-Jan-71 | 4 |
| 19 | Mr. | Rosten | Peter | F | 03-Oct-68 | 4 |
| 20 | Mr. | Mckee | Robert | S | 06-Mar-70 | 1 |
| 21 | Ms. | Baumann | Jennifer | A | 11-Dec-74 | 3 |
Table Name: STORE
| STORE_CODE | STORE_NAME | STORE_YTD_SALES | REGION_CODE | EMP_CODE |
| 1 | Access Junction | 1003455.76 | 2 | 8 |
| 2 | Database Corner | 1421987.39 | 2 | 12 |
| 3 | Tuple Charge | 986783.22 | 1 | 7 |
| 4 | Attribute Alley | 944568.56 | 2 | 3 |
| 5 | Primary Key Point | 2930098.45 | 1 | 15 |
Table Name: REGION
| REGION_CODE | REGION_DESCRIPT |
| 1 | EAST |
| 2 | WEST |
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Write foreign key constraints for the relationships in each of these tables. Make your own assumptions regarding cascading updates and deletions and justify those assumptions. (Hint: You can combine the SQL for your answers to parts A and B.)
Define the term referential integrity constraint. Give an example of a referential integrity constraint for the tables you created for question 1.8.
Consider the following table schemas (primary keys are underlined):
Company (cID, name, location)
Flight (cID, fnumber, departure, arrival, price:integer, numberOfSeats:integer)
Book (bID, cID, fnumber, customerID, seat, date)
Customer (customerID, name, address)
Draw Query-By-Example (QBE) tables for the following queries.
1.Find the names and addresses of customers who never booked a flight.
2. Find the names of customers who booked the flight to New York more than
once.
3.Find the names of the companies that have the biggest (in terms of the
number of seats) airplane.
4. Find the names of customers who booked flights to Boston and
Seattle.
5. Insert tuples into a new table CustomerCheck that stores the names and
addresses of customers along with their flight numbers who booked a flight from
New York to LA on 09/30/21.
Note: Query by example table is needed not just any table
Chapter 3 Solutions
Bundle: Database Systems Design, Implementation, & Management, Loose-leaf Version, 13th + MindTapV2.0, 1 term Printed Access Card
Ch. 3 - What is the difference between a database and a...Ch. 3 - Prob. 2RQCh. 3 - Prob. 3RQCh. 3 - What are the requirements that two relations must...Ch. 3 - Which relational algebra operators can be applied...Ch. 3 - Explain why the data dictionary is sometimes...Ch. 3 - A database user manually notes that The file...Ch. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQ
Ch. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Use Figure Q3.13 to answer Questions 1317. FIGURE...Ch. 3 - Create the table that results from applying a...Ch. 3 - Write the relational algebra formula to apply an...Ch. 3 - Create the table that results from applying an...Ch. 3 - Using the tables in Figure Q3.13, create the table...Ch. 3 - Prob. 18RQCh. 3 - Prob. 19RQCh. 3 - Prob. 20RQCh. 3 - Identify and describe the components of the table...Ch. 3 - Identify the primary keys. FIGURE Q3.22 THE...Ch. 3 - Identify the foreign keys. FIGURE Q3.22 THE...Ch. 3 - Create the ERM. FIGURE Q3.22 THE CH03_THEATER...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Prob. 26RQCh. 3 - What would be the conceptual view of the INDEX...Ch. 3 - Prob. 1PCh. 3 - Prob. 2PCh. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Prob. 5PCh. 3 - Prob. 6PCh. 3 - Prob. 7PCh. 3 - Prob. 8PCh. 3 - Create the relational diagram to show the...Ch. 3 - Prob. 10PCh. 3 - Prob. 11PCh. 3 - Create the relational diagram to show the...Ch. 3 - Prob. 13PCh. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Prob. 15PCh. 3 - Prob. 16PCh. 3 - For each table, identify the primary key and the...Ch. 3 - Prob. 18PCh. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Identify the TRUCK tables candidate key(s). FIGURE...Ch. 3 - For each table, identify a superkey and a...Ch. 3 - Prob. 22PCh. 3 - Prob. 23PCh. 3 - Prob. 24PCh. 3 - Create the ERD. (Hint: Look at the table contents....Ch. 3 - Prob. 26PCh. 3 - Prob. 27PCh. 3 - Prob. 28PCh. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying a...
Knowledge Booster
Similar questions
- 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.arrow_forwardWhat does it mean for two tables to be union compatible?arrow_forwardWrite 5 queries with explanations for online book store system,(USE MySQL)-- Write 5 queries. Your queries should do a task that is meaningful in online book store system.-- At least one that joins two or more tables-- At least one that include group functions-- At least one with one or more sub-query(es)-- At least one update-- At least one delete-- At least one include arithmetic functions-- At least one uses aliasarrow_forward
- A concise explanation of the many reasons why the use of tables in database design is a good idea could be of some use. Would you mind providing a brief remark on the subject of NULL?arrow_forwardThe one-to-many relationship between two tables is made by including the primary key from one table into the other, thus making it a: (SELECT ONLY ONE ANSWER) A)Compound key B) Foreign key C) Important key D)Primary keyarrow_forwardPlease may you answer the following questions. Create a Venn diagram with any topics of your choice and answer the following Q1: SQL Set Operation UNION: Choose any two or more of the data sets in your Venn diagram. Which elements would be included in the union of those data sets? Q2: SQL Set Operation INTERSECT: How would you describe one segment of your Venn diagram that represents the intersection of at least three of your data sets? Q3: SQL Set Operation EXCEPT: Choose any two or more of the data sets in your Venn diagram. Find an outlier element. Describe what excluding this outlier element using except logic means for your data sets. Q4: SQL Join Operation - INNER: Using all of the data sets in your Venn diagram, which segment represents the results of an inner join? If this does not apply to your specific Venn diagram, explain why not. Q5: SQL Join Operation - LEFT: Using any two of the data sets in your Venn diagram, how would you describe the results of a left join? Q6:…arrow_forward
- Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the diagram below The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply these…arrow_forwardHow about a rundown of the advantages that come with using tables in database systems? Could you perhaps write a few words on the topic of NULL?arrow_forwardWhat is a key feature of fifth normal form? A key step in this normal form has every determinant in a table as a candidate key. Foreign keys are created in this normal form. This normal form has the tables broken down into as many tables as possible to avoid redundancy. This normal form resolves any multivalued dependencies.arrow_forward
- How about a summary of the benefits associated with using tables in relational databases? Perhaps you could elaborate on the concept of NULL in a short essay.arrow_forwardWhat exactly is meant by the term "transitive"? It is possible to convert tables that are in the second normal form into tables that are in the third normal form; however, what is the rule for doing so?arrow_forwardLet's have a look at the benefits of using tables in relational databases. Could you perhaps provide some brief commentary on the concept of NULL?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr