Answered: If a non-key column determines a key…

Engineering

Computer Science

If a non-key column determines a key column, which normal form is violated?A) 1NFB) 2NFC) 3NFD) BCNF

CMPTR

3rd Edition

ISBN:9781337681872

Author:PINARD

Publisher:PINARD

Chapter17: Creating A Database

Section: Chapter Questions

Problem 4QY

See similar textbooks

Related questions

Q: select * from cast where cast_id=162652763; Use explain to display the query plan without creating…

A: the answer is given below

Q: create table emp ( eid number(7), fname char(20), lname char(20), salary number, primary key…

A: Since you have not provided the database name to write the SQL code so I am using MySQL database to…

Q: Create a SQL statement to Display the unique GENDER in the CLIENTS table. Sort the GENDER in…

A: SQL is an abbreviation for Structured Query Language. It is language used to write queries for…

Q: Please what is an independent clause

A: Actually, given question is independent clause...

Q: In Foreign Key Concept which of the following operation on referencing table will cause violation to…

A: In Foreign key concept referencing table is the table which contains the foreign key attribute. The…

Q: if (number>=capacity) enlarge_database (number+1);

A: In a database, whenever a new object is added, the following statement is executed to ensure that…

Q: Discuss the differences between triggers and stored procedures.

A: The differences are given below:-

Q: CIS111 Chapter 5 Lab Problems 3. Display the vendor name, number of invoices, average and total…

A: The following example shows three code examples. This first code example returns all rows (no WHERE…

Q: 31-Create a SQL statement to Display the number of clients for each CType with having less than 2…

A: Here we need group the CType using GroupBy clause and then use Having clause to select only those…

Q: fferentiate between left outer join and right outer join with respect to their functionality and…

A: Joins: A SQL Join statement is used to combine data or rows from two or more tables based on a…

Q: in sql The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the…

A: We are going to fill in the blanks where options are given: THE _____ clause specifies the table…

Q: A foreign key in a table (a) may not be composed of a single element (b) Should, in turn, be…

A: Answer : The Given MCQ Answer is option D) must belong to the primary key of the table in which it…

Q: Part of the primary key may not determine a non-key field.

A: If any relation/table is in second normal form means it dont have any partial functional…

Q: An index is automatically created for a FOREIGN KEY constraint. Select one: a. True b. False

A: When you define a foreign key constraint in database table, an index will not be created…

Q: A composite key is a column containing unique information. a. True b. False

A: To uniquely identify a record, a composite key consists of multiple attributes. However, this is not…

Q: 28. A key: a. must always be composed of two or more columns. b. can only be one column. c.…

Q: Describe how a foreign key is different from a primary key

A: Difference between foreign and primary key:

Q: The primary key and the candidate key must be distinguished.

A: Primary key The phrase main key refers to a candidate key that the database designer selects as the…

Q: A company that provides a movie-streaming subscription service uses a relational database to store…

A: According to the given description the E-R diagram and its explanation are given below: -…

Q: Problem 20.a Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16,…

A: Note:please don't post more than 1 question in 1 post. we are only allowed to solve one question.…

Q: Construct an appropriate SQL query (Create Table) for the following i. Member ii. Make

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: Write in SQL a command that creates the table Supplier according to the above description . Write in…

A: Note: since your question contain multiple-sub parts question but we can answer only first 3-sub…

Q: Create a SQL statement for the CLIENTS table using the table structure below

A: According to the question we need to create a SQL statement for the CLIENTS table using the table…

Q: 11. Which of the following statements is true with regard to BCNF tables, i.e. Boyce-Codd Normal…

A: The given question are multiple choice selected question.So can I explained in detail.

Q: explain the function of the FOREIGN KEY definition.

A: Functions of Foreign Key: It ensures that data is integral It is a constraint that prevents actions…

Q: Create a database named book-collection-db and table named: bookcollect. Your table should contain…

A: To create a new database in MySQL, you use the CREATE DATABASE statement Use a CREATE TABLE…

Q: Create a function to insert a new product into an existing order, include the product id, unit…

A: Answer : Step 1 The program code provided below has a class named Orders which has an order_id,…

Q: Perform the following function • Alter the table by adding a column salary • Alter the table by…

A: i) Alter table table_name add Salary int; ii) Alter table table_name Alter Column Name varchar(50);…

Q: Create a SQL statement to Display the CID, CName, and RType from both tables using the NATURAL JOIN…

A: Natural Join connects two tables based on attribute names and datatypes that are the same. The…

Q: Row is synonymous with the term: a. record b. relation c. column d. field

A: In the above mentioned question it asked us the Row is synonymous with the term.the answer is given…

Q: Write in SQL a command that creates the table Customers according to the above description. Write…

A: Create table Customers( customerID Char(5) NOT NULL, custFName Varchar2(35) NOT NULL, custLName…

Q: If a column has high selectivity or cardinality, which index type is most appropriate?a. IOTb.…

A: B-Tree: The indexes of the B-Tree are appropriate for high selectivity or cardinality. By sorting…

Q: Question 14 Write a SQL statement to un-grant the select and alter privilege from the user Ahmed.…

A: Revoke command is used to ungrant permission from a table for particular user. Syntax:- Revoke…

Q: One of the recommendations regarding indexes is to specify a unique index for each primary key

A: IntroductionConstraints in SQL Server permits process the principles at the column level within the…

Q: First normal form says: a. No nonkey columns depend on another nonkey column b. Every column…

A: First Normal Form says 1: It contains only atomic values 2:attrubute of table doesn't hold multiple…

Q: Identify the clause used to divide the rows in a table to smaller groups O a. WHERE O b. GROUP BY…

A: Explanation: Where clause is used to mention in which table we need to look for the data. Group by…

Q: tive query select v.A, t.B, v.D from Q v, Q w, Q t where v.D = w.D and t.D = 8 and t.A w.A and v.C =…

A: select m1.directorfrom movie m1, movie m2, movie m3, schedule s1, schedule s2 where m1.director =…

Q: in sql An index is automatically created for a FOREIGN KEY constraint. Select one: a. True b.…

A: b) False

Q: 1. Normalize the following table into first (1NF), second (2NF) a third (3NF) Normal form. Identify…

A: Primary key for the given relation is {Travelar ID, TestingUnitID} The given relation is already in…

Q: The following constraints are commonly used in SQL: AAA"Adding rows to a table" NOT NULL - Ensures…

A: Below I have provided the queries:

Q: create a unique Key Index

A: The CREATE UNIQUE INDEX command forms a exclusive index on a table where no duplicate values…

Q: Create a SQL statement to Display the RID, RType and a new column that will multiply the RATE to 30…

A: In step 2, i did the SQL statement to Display the RID, RType and a new column that will multiply the…

Q: You want to designate a unique index on the vehicle_id and VIN columns because together they filter…

A: Unique indexes are indexing that support maintaining data integrity by ensuring that no rows of data…

Q: Define the term Referential integrity constraint?

A: Given: Define the term Referential integrity constraint?

Q: QUESTION 2 Candidate keys O Chosen as preferred way to identify a row All of these None of these…

A: Given:

Q: 4.9 LAB - Select employees and managers with inner join The Employee table has the following…

A: Answer is given below. SELECT A.FirstName AS 'Employee', B.FirstName AS…

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

If a non-key column determines a key column, which normal form is violated?
A) 1NF
B) 2NF
C) 3NF
D) BCNF

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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 SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD.
Please what is an independent clause
24-Create a SQL statement to Add a CHECK constraint on the ROOM_STATUS column in the ROOMS table. It must accept Available or Occupied values only.
10. The minimal set of super key is called a. Primary key b. Secondary key c. Candidate key d. Foreign key
Answer the given question with a proper explanation and step-by-step solution. c. Create a relastionship: You need to add a new column called DeptID in the Employee table, it will be the foreign key in this table, it should be text data type and 5 characters in length. Make sure you enter one of the corresponding departmentID's values (i.e., ECON, MIS, and BUS) for this column in the Employee table for this newly created DeptId column that you have entered in the Department table previously. Then, use the Relationships tool under Database Tools to create a relationship between the Department Table and the Employee table, i.e., connecting the two tables together via the primary key (DepartmentID in Department Table) and foreign key pair (DeptID in the Employee Table and choose Enforce Referential Integrity to set the integrity contraint between the foreign key and primary key
What type of statement is this?a) DMLb) DDLc) Viewd) Integrity constraint
The essential condition of third normal form is automatically satisfied whenA) a table has only one non-key columnB) a table has only one key columnC) a table has only one primary keyD) a table has no foreign key
PL/SQL Problems Q1. Create a function to calculate a shopper’s total spending, excluding shipping and tax amount, with Brewbean’s site in a particular year. Exception handling is needed. Use an anonymous block to call the function and output the result. Q2.Create a procedure to allow an employee in the shipping department to update an order status to add shipping information. The BB_BASKETSTATUS table lists events for each order so that a shopper can see the current status, date, and comments as each stage of the order process are finished. Use an anonymous block to test your procedure. Q3.Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. Use an anonymous block to call the function and output the result. Q4.Create a function to determine the total pledge amount for a project. Use the function in an SQL statement to…
An index is automatically created for a FOREIGN KEY constraint. Select one: a. True b. False
In Structure Query Information Select all columns from the jobs table using an asterisk.2. Select only job title, min salary, and max salary columns from the jobs table.3. Select all columns from the d_partners table by writing out all of the columns inthe select statement.4. Using the d_partners table, display the id, and then concatenate the first_nameand last_name together with a space in between the two columns. Give theconcatenated column an alias of NAME. Be sure to use the optional ASkeyword.5. Using the job_grades table, show the grade level, and then subtract thelowest_sal from the highest_sal to show the amount of variance there is for eachgrade level. Give the calculated column an alias of Salary_Variance. Do notuse the optional AS keyword.6. Using the employees table, show an unduplicated list of department_id’s.7. Change the SELECT statement you built for question 4, adding a single columncalled Partner_Information that concatenates the partner’s…
Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger (model trigger) to ensure that no employee of salary less than 20000 can be inserted in the database. Show the result for your trigger condition by inserting a new row.
36-Create a SQL statement of a read-only view, name it as ViewE, that will contain Gender and the number of clients per gender in the CLIENTS table.

SEE MORE QUESTIONS

Recommended textbooks for you

CMPTR

Computer Science

ISBN:

9781337681872

Author:

PINARD

Publisher:

Cengage

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

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

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

CMPTR

Computer Science

ISBN:

9781337681872

Author:

PINARD

Publisher:

Cengage

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

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

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS