Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 6, Problem 16RQ
A table is in __________ normal form when it is in __________ and there are no transitive dependencies.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
(TCO 5) Aggregate functions are used to
Group of answer choices
list only unique values.
add primary and foreign key designations.
add a column to a table.
summarize data across multiple rows.
3.
CREATE TABLE Employee (name VARCHAR(),e_id int,mgr_id INT,PRIMARY KEY (e_id));
CREATE TABLE Department (name VARCHAR(),d_id INT ,PRIMARY KEY (d_id));
// Assume tables are inserted
a) find the avg num of employees managed by each manager
b) find managers who are managing m0re employeez than avg num of employees per manager
a. Normalize the Bank Accounts Table to 1NF by increasing the records in the existing table.
b. Normalize the Bank Accounts Table to 1NF by creating a new separate table in addition to the existing table.
Chapter 6 Solutions
Database Systems: Design, Implementation, & Management
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Write the two SQL command sequences required to: a.Create a temporary table named TEMP_1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT. b.Copy the matching EMP_2 values into the TEMP_1 table.arrow_forward1-Write the syntax to create a relational table called staff that references an object table called people that was created using an people_type. Relational Table Name staff attribute staff_id attribute department attribute personarrow_forwardA(n) ___________ key is a column in one table that references a primary key in another related table. A(n) ___________ source connects data-bound controls to a dataset.arrow_forward
- What does the term "transitive" mean? What is the rule for converting tables in the second normal form to tables in the third normal form?arrow_forward183. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth. a. Tablespace b. Segment c. Extent d. Blockarrow_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
- A view is updatable when it is derived from joining two base tables on the _________ commandarrow_forwardCreate a view of the Join of Deposit and Withdraw transactions to Bank Branch UNION with the join of Bill Payment and Debit Purchase, or Return transactions to Merchant (i.e., all transactions with appropriate reference name.). BranchNbr stores RefNbr of either 'D', OR 'W' transactions and MerchantNbr stores RefNbr of either 'B', 'P' or 'R' transactions. GIVEN THE BELOW: --THIS CREATES THE TRANSACTION TABLE: CREATE TABLE Transaction ( TxNbr INT PRIMARY KEY, AccountNbr INT, TxTypeCode VARCHAR(250), TxDate DATE, TxTime TIMESTAMP, TxAmount FLOAT, RefNbr INT, FOREIGN KEY (AccountNbr)REFERENCES Account(AccountNbr), FOREIGN KEY (TxTypeCode) REFERENCES TxType(TxTypeCode)); --THIS CREATES THE BANK BRANCH TABLE:CREATE TABLE BankBranch ( BranchNbr INT PRIMARY KEY, BranchName VARCHAR(250)); --THIS CREATES THE MERCHANT TABLE:CREATE TABLE Merchant ( MerchantNbr INT PRIMARY KEY, MerchantName VARCHAR(250)); -- Insert test data…arrow_forward- Create a new table called CLERKS based on EMP table so that it contains all the clerks in EMParrow_forward
- Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following rows ID DEPT SALARY NAME 100 SALES 40000 Smith 101 RD 38000 Terry 102 HR 60000 David 103 SALES 58000 Ellie 104 RD 70000 Judy The DEPARTMENT table contains two attributes, DEPTNAME and PHONE, and has the following rows: DEPTNAME PHONE RD 8596001234 SALES 8596005555 HR 8596009876 A.) The EMPLOYEE table needs to enforce the following integrity constraints: • The ID is the primary key. • The DEPT column is a foreign key that references the DEPTNAME in the DEPARTMENT table, so that any value that appears in the DEPT column should also exist in the DEPARTMENT table. • The value for the NAME column can never be null. What should be the statement used to create the EMPLOYEE table, if 1) the table was created as a partitioned table such…arrow_forwardWhat are the advantages of sorting a table over sorting records with a query? Which method is the most efficient? Why?arrow_forwardWhat is Temporary Table and what are the two types of it? They are tables just like regular tables but the main difference is its scope.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 LearningDatabase 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
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY