MID TERM I
When the primary key of one relation is placed into a second relation, it is called a ________. A) field key B) referential integrity C) foreign key D) candidate key E) relocated key
C) foreign key
In SQL Server, the starting value of a surrogate key is called the ________. A) identity B) identity increment C) identity Start D) identity Seed E) identity property
D) identity Seed
In the normalization process, if you find a candidate key that is not a determinant then you should not ________. A) place the columns of the functional dependency in a new relation B) make the determinant of the functional dependency the primary key of the new relation C) leave a copy of the determinant as a foreign key in the original relation D) rename the determinant to another attribute description E) create a referential integrity constraint between the original relation and the new relation
D) rename the determinant to another attribute description
A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).
FALSE
A key must be unique.
FALSE
A relational database stores data in the form of lists.
FALSE
Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems.
FALSE
Candidate keys may or may not be unique.
FALSE
In the normalization process, if you find a candidate key that is not a primary key, then you have determined that the relation needs to be broken into two or more other relations.
FALSE
In the normalization process, it is not necessary to identify all the functional dependencies in a relation.
FALSE
In the relational model, each row of a table contains data that represents an attribute of the entity.
FALSE
Microsoft Access forms can only contain data from one table.
FALSE
Most organizations create and use their own database management system (DBMS) products.
FALSE
Referential integrity constraints must be enforced by the application program.
FALSE
SQL stands for Structural Question Language.
FALSE
Since surrogate keys are used to uniquely identify rows, their values are normally displayed prominently on all forms and reports for the users to see.
FALSE
Usually, a database table containing both rows and columns is designed to store data for exactly two themes.
FALSE
While the relational model for databases appears to hold much promise, few commercial databases have implemented it.
FALSE
In relational databases, query requests use a language called ________.
Structured Query Language (SQL); Structured Query Language; SQL
A double arrow notation, A →→ B, is used to indicate a multivalued dependency.
TRUE
By separating data into tables containing data on only one theme each, making changes to the data is simplified.
TRUE
Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.
TRUE
Every cell in a relation can hold only a single value.
TRUE
Given the functional dependency for the attributes of ENTITY1, X → (A, B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).
TRUE
If the condition exists such that knowing the value of attribute X determines the value of attribute Y, then attribute Y is functionally dependent on attribute X.
TRUE
In the normalization process, if you find that every determinant in a relation is a candidate key, then you have determined that the relation is well formed.
TRUE
In the normalization process, it is necessary to identify all the determinants in a relation.
TRUE
Null values can cause problems because they are ambiguous.
TRUE
Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL).
TRUE
Surrogate key values have no meaning to the users.
TRUE
The DBMS is used to create the database itself.
TRUE
The DBMS receives data update requests from the application program.
TRUE
The first step of the normalization process is to identify all the candidate keys of a relation.
TRUE
The primary key is used both to identify unique rows in a relation and to represent rows in relationships.
TRUE
The purpose of a database is to help people keep track of things.
TRUE
To be considered a composite key, a key must contain at least two attributes.
TRUE
To create a relationship in Microsoft Access, we drag and drop the ________ of a table.
primary key
Which of the following is not true of surrogate keys? A) They are meaningful to the users. B) They are numeric. C) They are usually generated by the DBMS. D) They are unique. E) They are usually hidden on forms and reports.
A) They are meaningful to the users.
A key that contains more than one attribute is called a(n) ________. A) composite key B) complex key C) multi-key D) n-key E) candidate key
A) composite key
The first step of the normalization process is to ________. A) identify all the candidate keys of a relation B) identify all the foreign keys of a relation C) identify all the functional dependencies of a relation D) identify all the determinants of a relation E) split the relation into two or more new relations
A) identify all the candidate keys of a relation
In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that ________. A) the relation is well formed B) the relation needs to be broken into two or more new relations C) surrogate keys in the relation may not be correctly linked to other relations D) the relation needs to have foreign keys added in order to be correctly linked to other relations E) referential integrity constraints concerning the relation need to be established
A) the relation is well formed
A relational database is ________. A) a self-describing collection of related tables B) a collection of forms and reports that support a given purpose C) a library of queries and data files for querying D) a set of applications and the data sets for those applications E) a set of metadata
A. a self-describing collection of related tables
What is the name of Microsoft's cloud services?
Azure
40) Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)which of the following statements is not known to be true? A) MedicineCode is a determinant. B) MedicineName is a determinant. C) Manufacturer is functionally dependent on MedicineCode. D) ShelfLife is functionally dependent on MedicineCode. E) MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage).
B) MedicineName is a determinant.
The statementSELECT STUDENT.StudentNumber, STUDENT.StudentName,FROM STUDENTWHERE STUDENT.StudentNumber = S12345678;is an example of ________. A) QBE B) SQL C) QLE D) C++ E) Java
B) SQL
Microsoft SQL Server is an example of a ________. A) database B) database management system C) data manipulation system D) table E) list manager
B) database management system
In the normalization process, it is not necessary to ________. A) identify all the candidate keys of a relation B) identify all the foreign keys of a relation C) identify all the functional dependencies of a relation D) identify all the determinants of a relation E) determine if every determinant is a candidate key
B) identify all the foreign keys of a relation
Microsoft Access 2019 database files are stored using the file extension ________. A) .adb B) .asp C) .accdb D) .mdb E) .sql
C) .accdb
Given the relations: STUDENT (SID, StudentName, Major, AdvisorID)ADVISOR (AdvisorID, AdvisorName, Office, Phone) such that each student is assigned to one advisor, which of the following is true? A) SID is both a primary key and a foreign key. B) AdvisorName is a determinant. C) AdvisorID is a foreign key. D) Phone is a candidate key. E) Major is a candidate key.
C) AdvisorID is a foreign key.
The creation of a database and its tables is a function of which component of the database system? A) Users B) Application C) DBMS D) Database E) Web server
C) DBMS
A surrogate key may be appropriate under which of the following circumstances? A) The primary key is not unique. B) The primary key is numeric. C) The available candidate keys would be prone to typographical errors. D) The available candidate keys have little meaning to the users. E) The relation only has one attribute.
C) The available candidate keys would be prone to typographical errors.
primary key is ________. A) not required to be unique B) used to represent columns in relationships C) a candidate key D) always automatically generated by the DBMS E) comprised of exactly one attribute
C) a candidate key
Which of the following is true about a key? A) It may be unique. B) It may be nonunique. C) It can only identify one row. D) Both A and B E) None of the above
D) Both A and B
candidate key is ________. A) never a primary key B) a combination of two or more attributes C) is always automatically generated by the DBMS D) a candidate to be the primary key E) None of the above
D) a candidate to be the primary key
A relational database stores data in the form of ________. A) lists B) forms C) columns D) tables E) spreadsheets
D) tables
Today almost every commercial database is based on ________. A) lists B) the hierarchical model C) the linked-list model D) the relational model E) the object-oriented model
D) the relational model
Which of the following functional dependency diagrams accurately represents the following situation:• A campus has many buildings.• Each building has a unique name.• Each building has many rooms.• All rooms in any given building are numbered sequentially starting at "101."• Each room has a certain capacity, although many rooms in the same building or different buildings may have the same capacity.• Each room is assigned to a single department.• A department may have many rooms in one or more buildings, each with the same or different capacities. A) BuildingName → (RoomNumber, Capacity, Department) B) RoomNumber → (BuildingName, Department, Capacity) 20 C) (Department, Capacity) → (BuildingName, RoomNumber) D) (BuildingName, Capacity) → (Department, RoomNumber) E) (BuildingName, RoomNumber) → (Capacity, Department)
E) (BuildingName, RoomNumber) → (Capacity, Department)
In the normalization process, if you find a candidate key that is not a primary key then you should ________. A) place the columns of the functional dependency in a new relation B) make the determinant of the functional dependency the primary key of the new relation C) leave a copy of the determinant as a foreign key in the original relation D) remove the determinant from the original relation E) None of the above
E) None of the above
Regarding Big Data, what does the term NoSQL really mean? A) No SQL used B) NortonOS Query Language C) Notational Query Language D) Non-Blocking Query Language E) Nonrelational Database
E) Nonrelational Database
Which of the following would not be an example of database metadata? A) Names of tables in a database B) Properties of tables in a database C) Names of columns in a database and their associated tables D) Properties of columns E) Queries against records in the database tables
E) Queries against records in the database tables
A database may be used to help people with all of the following except ________. A) track which student is assigned to a particular advisor B) know the current inventory levels of products their company sells C) check on the estimated arrival time of an incoming flight at an airport D) look up their checking account balance over the Internet E) debug existing program code
E) debug existing program code
The component of a database that makes it self-describing is the ________. A) related tables B) applications C) library D) data set E) metadata
E) metadata
________ was the developer of the relational model for databases.
E. F. Codd
The unique keys that are not chosen to be the primary key are called ________ keys.
alternate
A key that contains two or more attributes is called a(n) ________ key.
composite
In a database system, the ________ creates and processes forms.
database application
To be a well-formed relation, every ________ in the relation must be a candidate key.
determinant
When the primary key of one relation is placed in a second relation to represent a relationship, the attribute in the second relation is called a(n) ________ key.
foreign
The relationship between two attributes that denotes that if the value of the first attribute is known, then the value of the second attribute can be determined, is called a(n) ________.
functional dependency
A(n) ________ is one or more columns of a relation that is used to identify a row.
key
Data that the database keeps about its own structure is called ________.
metadata
It is almost always best to design a table in a database so that it contains data on ________ theme.
one
The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.
primary
A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n) ________ constraint.
referential integrity
Any table that meets the requirements of a(n)________ is in first normal form.
relation
A(n) ________ is a unique, numeric value that is appended to the relation to serve as the primary key.
surrogate key
A relational database stores data in the form of ________.
tables
