1. Every Boyce code normal form is in a. First Normal Form b. Second Normal Form c. Third Normal Form d. All the above 2. A functional dependency is a relationship between or among: a. Entities b. Rows c. Attributes d. Tables 3. Insert, Delete and Update queries modify the of a table. a. Rows b. Columns Constraints

1. Every Boyce code normal form is in a. First Normal Form b. Second Normal Form c. Third Normal Form d. All the above 2. A functional dependency is a relationship between or among: a. Entities b. Rows c. Attributes d. Tables 3. Insert, Delete and Update queries modify the of a table. a. Rows b. Columns Constraints

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

32. In a relational model, relations are termed as a. Tuples b. Attributes c. Rows d. Tables
A) The following relations kind a part of a on-line database (the relations area unit self- explanatory): CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown, Balance, Cname) ORDER(Order.# Date, Cust#.) ORDERLINE(Order#, Part#, Amount-Ordered) PART(Part#., Desc, Stock, Item-Class, Unit -Price) a. Design a physical ER for the above scenario. b. With respect to this relative schema, write SQL statements for the subsequent queries: 1. List the name of the client United Nations agency has placed Order 123 (i.e. Order: = 123). 2. List the names of shoppers United Nations agency in Cardiff and have ordered half 456 (i.e. Part. 456). 3. List the order numbers (Order) for orders that contain a minimum of three elements and also the quantity ordered are minimum of ten. 4. List the outline (Desc), of these elements that the typical quantity ordered is bigger than the number ordered for half .6 (Part. = 456) so as 123.(Order..123).
A)Which of the following are used to indicate cardinality symbols? a.WITHb.Pc.None of the aboved.Both A and B aboveB)State TRUE or FALSE. In a ternary relationship, an entity associates with itself. a.This is trueb.This is falseC)In database design, it is possible to give relationships names. a.This is trueb.This is false
5. Minimal Superkeys are called a. Schema keys b. Candidate keys c. Domain keys d. Attribute keys
Which one of the following statement is not true: A complex object is formed by combining other objects in a set of complex relations Abstract data type (ADT) defines a set of similar objects all other three answers are correct A complex object is formed by combining other objects in a set of complex relations
113. The template conclusion is a set of tuples that must be included in the relations in the template dependency called a. constraint generating templates b. tuple generating templates c. schema generating templates d. relation filtering template
. Students(stulD, lastName, firstName, major, credits) Faculty (facID, name, deptName, rank) • Classes(classNumber, facID, schedule, room) • Enrolls(stulD, classNumber, grade) The primary keys are underlined. The referential integrity constraints are as follows: . the column facID of relation Classes that references table Faculty, . the column stulD of relation Enrolls that references table Students, and the column classNumber of relation Enrolls that references table Classes. The following query is intended to retrieve the number of all classes taught by John Smith in the CST department. However, this query does not work properly. There are at least two faculty members who share the name, John Smith. Briefly explain and show the corrected SQL query_ why. SELECT classNumber FROM Classes WHERE facID= (SELECT facID FROM Faculty WHERE name='John Smith' AND deptName='CST');
Relational model: In the personal model, data are prearranged in tables, which contain of table. A data in a table is called fields. Fields in a db table are also referred as qualities of a db object. A group of related fields are called as a record, which I also called as db object or entity. A group of records are called a table. Keys in a relational db table refer to a key field. To identify each record in a table, there must be at least one data field that should be unique. That is, a corresponding data field of every record should be unique. Therefore, key field is used to identify the unique record from a collection of records.
15. A table is said to exhibit referential integrity if: a. it has no foreign key. b. it has a foreign key, and all the foreign key values are unique and not null. c. it has a foreign key, and all the foreign key values are referenced in another table's primary key attribute. d. it has a foreign key, which is also a component of its primary key.
23. Which of the following is a group of one or more attributes that uniquely identifies a row? a. Key b. Determinant c. Tuple d. Relation
You have an application domain that consists of Cities, Towns, and Neighborhoods. A City has a name, zip code, state, and a country. A Town has a name, zip code, state, and country. A Neighborhood has a name, coordinate, and population. Using a relational model, what are Students, Courses, and Sections called? Select one: a. Attributes b. Constraints c. Entities d. Relations
Material : Relational Algebra Course : Database Systems Create a Relational Algebra From Entity Relational Diagram (ERD) Below for:a) Displays books published in the last 5 years from 2020.b) Displays details of customers who have done shopping (using the Join operator)c) Displays email customers who have done shopping (using the Set operator)d) Displays the ISBN book that has never been purchased (using the Set operator)