EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 2SCGC
To determine
To identify the fields that cause the table no longer to be in third normal form and the normal form of denormalized table.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
One of the TAL Distributors database's denormalized tables is as follows: The Customer table is no longer in third normal form due to which column or fields (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum, RepName)? In this example, what is the denormalized table's normal form?
Question: List the names of any pair of boats that have the same type. For example, one pair would be Anderson II and Escape, because the boat type for both boats is Sprite 4000. The first name listed should be the major sort key and the second name should be the minor sort key.
Database:
CREATE DATABASE ALEXAMARA; USE ALEXAMARA;
CREATE TABLE MARINA_SLIP(SLIP_ID DECIMAL(4,0) PRIMARY KEY,MARINA_NUM CHAR(4),SLIP_NUM CHAR(4),LENGTH DECIMAL(4,0),RENTAL_FEE DECIMAL(8,2),BOAT_NAME CHAR(50),BOAT_TYPE CHAR(50),OWNER_NUM CHAR(4) );CREATE TABLE OWNER(OWNER_NUM CHAR(4) PRIMARY KEY,LAST_NAME CHAR(50),FIRST_NAME CHAR(20),ADDRESS CHAR(15),CITY CHAR(15),STATE CHAR(2),ZIP CHAR(5) );
INSERT INTO MARINA_SLIPVALUES(1,'1','A1',40,3800.00,'Anderson II','Sprite 4000','AN75');INSERT INTO MARINA_SLIPVALUES(2,'1','A2',40,3800.00,'Our Toy','Ray 4025','EL25');INSERT INTO MARINA_SLIPVALUES(3,'1','A3',40,3600.00,'Escape','Sprite 4000','KE22');INSERT INTO MARINA_SLIPVALUES(4,'1','B1',30,2400.00,'Gypsy','Dolphin…
Note: Use MYSQL
Create a database named book-collection-db and table named: bookcollect. Your tableshould contain the following columns: Title, Author, Genre (Children’s, Romance,Thriller, Fantasy, etc.), Publisher, Copyright Date, ISBN Number, Category (Fiction/Nonfiction), Overview, Link Where to Buy, and Price. Create 30 rows containing list of bookwith varied genre.
Chapter 8 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 8 - Prob. 1RQCh. 8 - Prob. 2RQCh. 8 - Prob. 3RQCh. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - Prob. 8RQCh. 8 - Prob. 9RQCh. 8 - Prob. 10RQ
Ch. 8 - Prob. 11RQCh. 8 - Prob. 12RQCh. 8 - Prob. 13RQCh. 8 - Prob. 14RQCh. 8 - Prob. 15RQCh. 8 - Prob. 16RQCh. 8 - Prob. 17RQCh. 8 - Prob. 18RQCh. 8 - Prob. 19RQCh. 8 - Prob. 20RQCh. 8 - Prob. 1TDECh. 8 - Prob. 2TDECh. 8 - Prob. 3TDECh. 8 - Prob. 4TDECh. 8 - Prob. 1CATCCh. 8 - Prob. 2CATCCh. 8 - Prob. 3CATCCh. 8 - Prob. 4CATCCh. 8 - Prob. 1SCGCCh. 8 - Prob. 2SCGCCh. 8 - Prob. 3SCGCCh. 8 - Prob. 4SCGC
Knowledge Booster
Similar questions
- Using the Henry Books database,Henry Books no longer carries books written by Barbara Owen. Delete this author from the authors table. You will insert 2 snips for this question. What construct did you use to delete author Barbara Owens? Insert the snip of the construct used: Insert the snip of the authors table. Be sure all rows are displayed:arrow_forwardUsing the Henry Books database, add the new title from Stephen King to the wrote table: Book code = 3578 Author number = 6 Edition = 1 You will insert 2 snips for this question. What construct did you use to add a row to the wrote table. Insert the snip of the construct used: Insert the snip of the wrote table. Be sure the new row is displayed:arrow_forwardWrite a query to display the first name, last name, and email address of employees hired from January 1, 2005, to December 31, 2014. Sort the output by last name and then by first name. Write the answer to each query and the result of the query (screen capture). You should submit all design work, program documentation, and relevant sample screen shots of your implementation. A script file with all database creation and table populating is required.arrow_forward
- Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single dayarrow_forwardSelected columns are removed from a table using a relational database's "select" method.It's possible that I'm mistaken.arrow_forwardIn the Testa EV database described in the previous question, fill in the blanks in the following MySQL statement to list (in this order) all the part numbers of components of 'EV Dashboard' (with Part_No=1) and their quantities; sort the results in ascending order of quantity of components (i.e., components with small quantities are listed first). (Please ensure correctness in the spelling of all names and commands. Do not enter unnecessary symbols such as spaces or commas)arrow_forward
- Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULLarrow_forwardPlease write a view to list the project name, staff name, and the staff’sbranch city for the staff who are working on the same project more than one time. You should useProject, Staff2, Branch, and Working tables in the dreamhome database. The output column headershould be Project_name, Staff_name, Branch_city. The staff_name should combine fname and lnamewith a space in between.arrow_forwardList all active students in June by name. (Make up names and other data if you are actually building a prototype database.) Include the number of hours students received tutoring and how many lessons they completed.arrow_forward
- Not all versions of this database include referential integrity constraints for all foreign keys. Use whatever commands are available for the RDBMS you are using, investigate if any referential integrity constraints are missing. Write any missing constraints and, if possible, add them to the associated table definitions.arrow_forwardYou have a list of all your contacts details that you would like to store in a database. Your goal is that when a record is inserted in contacts table, you also want this record to be stored (inserted) in a backup table. Assume you have the two tables created: CONTACTS and CONTACTS_BACKUP. These two (2) tables have the same records. The CONTACTS table have the following columns: CONTACT_ID (Primary_Key), FIRSTNAME, LASTNAME and MOBILE_NO. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 1 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 The CONTACTS_BACKUP table have the same columns and records as the CONTACTS table. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 You now need to keep both tables in sync so that when a record is inserted into the CONTACTS table it should automatically be inserted into…arrow_forwardTo make the TAL Distributors database run more efficiently, the DBA denormalized part of the data, resulting in the following structure for one of the tables: A third normal form violation has occurred in the Customer table, which contains the following fields: CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum, and RepName. Which field(s) are to blame? What would the typical shape of the denormalized table be in this case?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr