Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 2.5RQ
Program Plan Intro
Table:
The table is constructed with rows and columns.
- Table contains a group of related records.
- Column represents a field and row represents a record.
- Field is the information of a single item.
- Record is a collection of related fields; it contains all the necessary information of the specific object.
- In a relation all the columns are filled with their respective value but in a table even though it is a single cell, it is filled with the multiple value.
- Therefore, a table is not considered as a relation.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What is an unnormalized relation? Is it a relation according to the definition of the word relation?
Give an example of a table that is not a relation (other than one from this chapter).
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram:
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…
Chapter 2 Solutions
Database Concepts (7th Edition)
Ch. 2 - Prob. 2.1RQCh. 2 - Define the term entity, and give an example of an...Ch. 2 - Prob. 2.3RQCh. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - Prob. 2.7RQCh. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - Define the term unique key and give an example.
Ch. 2 - Prob. 2.11RQCh. 2 - Prob. 2.12RQCh. 2 - Prob. 2.13RQCh. 2 - Describe four uses of a primary key.Ch. 2 - Prob. 2.15RQCh. 2 - Prob. 2.16RQCh. 2 - Prob. 2.17RQCh. 2 - Explain the term foreign key, and give an example.Ch. 2 - Prob. 2.19RQCh. 2 - Prob. 2.20RQCh. 2 - Explain three possible interpretations of a null...Ch. 2 - Give an example of a null value (other than one...Ch. 2 - Prob. 2.23RQCh. 2 - Prob. 2.24RQCh. 2 - Prob. 2.25RQCh. 2 - Prob. 2.26RQCh. 2 - Prob. 2.27RQCh. 2 - Define the term primary key in terms of functional...Ch. 2 - Prob. 2.31RQCh. 2 - Examine the data in the Veterinary Office...Ch. 2 - Prob. 2.33RQCh. 2 - Describe a modification problem that occurs when...Ch. 2 - Prob. 2.35RQCh. 2 - Prob. 2.36RQCh. 2 - Prob. 2.37RQCh. 2 - Apply the normalization process to the Veterinary...Ch. 2 - Prob. 2.39ECh. 2 - Prob. 2.40E
Knowledge Booster
Similar questions
- Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: 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…arrow_forwardIf you assume that a relation has no duplicate data, how do you know there is always at least one primary key?arrow_forwardwhich rules apply to desigining table with less redundancy? a) Binary Relationship b) Reflective Relationship c) Weak entity d) Normal formarrow_forward
- Discuss the differences between the candidate keys and the primary key of a relation.arrow_forwardNORMALIZATION EXERCISE Based on the given relation schema below, perform normalization up to 3NF. Write your answer in below space ORDER (Order_ID,Date,Cust_ID,Cust_Name,State,City,ItemNO,ItemDescription,ItemPrice,Quantity) 1NF 2NF 3NFarrow_forwardNormalize the following given data to 1/2/3 NF. State the relations schema after everynormalization.arrow_forward
- When you add a time property to a relation, it becomes a temporal relation. Will the useful links still work? In a time database, how is the problem solved?arrow_forwardWhat three situations make it necessary to make a substitute key instead of the main key of a relation?arrow_forwardA relation may not have a super key. (a) True (b)Falsearrow_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
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