The relational model this database would look like sales cust

ACIS 5504 – First Half Practice Questions (1)

1) The ________ translates user requests into a computer code that is required to fulfill those requests.

4) An index can be used to .

a.) document the structure of the database itself b.) improve the performance of the database
c.) reduce data dependency for application programs better represent the users’ perspectives of the data d.)
e.) All of the above.

8) A properly constructed database can be described as a list that has been broken up into a group of pieces, each of which has a single "theme" or purpose. Breaking the list into these pieces is done using a process called .

a.) database construction
b.) table making
componentization c.)
d.) normalization
e.) relating

11) The industry standard supported by all major DBMSs that allows tables to be joined together is called __________.

a.) Sequential Query Language (SQL)
b.) Structured Question Language (SQL)
c.) Structured Query Language (SQL)
d.) Relational Question Language (RQL)
e.) Relational Query Language (RQL)

15) Where does the DBMS store the definitions of data elements and their relationships?

a.) data file

a.) table

b.) relation

a.) can be a single attribute

b.) can be a group of attributes taken together

 (C, D)?

a.) A is the determinant of C

19) Given the functional dependency (A, B)  C, (A, B) is a(n) _____________________.

a.) independent variable

20) Which of the following is not true about normalization?

a.) produces relations with a single theme

21) A relation is in 2NF if it is in 1NF and all its non-key attributes are .

a.) dependent on part of the primary key

22) A relation is in third normal form if it is in second normal form and .

a.) is dependent on part of the key

EMPLOYEE (SSN, SupervisorID, Department)

Key: SSN

23) Which type of dependency is present in the EMPLOYEE relation above?

f.) deletion dependency

24) A relation is in Boyce-Codd normal form if it is in 3NF and .

e.) there is more than one primary key

25) A “candidate key” is .

e.) the primary key selected to be the key of a relation

26) In the context of a database table, the statement “A determines B” indicates that _______.

27) If two attributes A and B have a one-to-one attribute relationship, it is shown as

b.) the two attributes usually only appear in one relation together

c.) other attributes that are functionally dependent on either of them may appear in a

a.) condensed

b.) physical

______________.

b.) foreign key

c.) supertype

c.) seldom changing

d.) a and b

c.) They tend to slow database performance.

d.) They are hidden on forms and reports.

c.) efficient storage use

d.) data integrity problems

d.) subtype constraint

e.) referential integrity constraint

d.) relations

e.) keys

d.) model

e.) None of the above is correct.

d.) the keys of both tables are joined into a composite key (or a new key is created)

e.) c and d

d.) the primary key data do not have to be unique

40) It may take more than a single attribute to define functional dependence; that is, a key must

d.) foreign

41) The characteristics of a thing are described by its _______________________ .

42) This diagram refers to what kind of relationship?

Based on the following table, answer the questions (43-45) below:

SALES TABLE

a.) 1NF

b.) 2NF (has no partial, but transitive dependency)

b.) Cust_ID  Salesperson

c.) Cust_ID  Region

Salesperson (Salesperson, Region)

b.) Sales (Cust_ID, Name, Salesperson)

46) A table that displays data redundancies yields _______.

a.) inconsistencies

College (Student_ID, Staff_ID, Class_Code, Enroll_Grade)

Functional Dependencies:

Class (Class_Code, Staff_ID)

Solution: No partial or transitive dependency, but Class_Code needs to be a candidate

c.) BCNF

d.) 4NF

C  B

a.) 2NF

1) The ________ translates user requests into a computer code that is required to fulfill those requests.

a.) Database Modeling System
b.) Database Management System
c.) Data Business Model System
d.) Relational Model Manager
f.) Data Business Management Service

a.) document the structure of the database itself b.) improve the performance of the database
c.) reduce data dependency for application programs better represent the users’ perspectives of the data d.)
f.) All of the above.

5) Data models were developed to _________________.
a.) model real-world events or conditions
b.) deposit data within a single file
c.) keep data within multiple data repositories
d.) allow DBMSs to maintain loose control over the database activities

a.) database construction
b.) table making
componentization c.)
f.) normalization
g.) relating

9) A relational database model _____________?

a.) Sequential Query Language (SQL)
b.) Structured Question Language (SQL)
c.) Structured Query Language (SQL)
d.) Relational Question Language (RQL)
e.) Relational Query Language (RQL)

12) What relationship is expressed with the phrase “Painter paints Paintings”? a.) 1:M
b.) 1:1
c.) M:1
d.) M:N

b.) 1

c.) 2

c.) data dictionary

e.) data map

d.) field

e.) file

d.) must be functionally determined by another attribute

f.) All of the above are true.

c.) A and B together determine D

g.) C and D together determine A

c.) determinant

d.) composite determinant

c.) reduces the number of functional dependencies in the schema

d.) reduces anomalies

c.) independent of the primary key

d.) independent of each other

c.) is independent of the key

d.) has no transitive dependencies

SSN  SupervisorID

SupervisorID  Department

b.) transitive dependency

c.) determinant dependency

b.) every determinant is a primary key

c.) every attribute is a candidate key

b.) any group of attributes that are a determinant

c.) functionally dependent on the non-key attributes

b.) you need not know the value of attribute A to look up the value of attribute B

c.) knowing the value of attribute B, you can look up the value of attribute A

28) When creating a database with attributes that have a one-to-one attribute relationship

________ .

d.) either of the attributes can appear in relations without the other

e.) all of the above

d.) conceptual

30) If two attributes A and B that have a many-to-many attribute relationship, and a third

31) After converting an ERD to a relational model, the identifier of the “entity” becomes the

_____________ of the newly formed “table” or “relation”.

32) The ideal primary key is .

a.) short

33) Which of the following is not true about surrogate keys?

a.) They are identifiers that are supplied by the system, not the users.

34) Data redundancy produces .

a.) slower lookups

a.) primary key constraint

b.) overlap constraint

a.) data

b.) files

a.) instance

b.) relationship

a.) the key of the child is placed as a foreign key into the parent

b.) the key of the parent is placed as a foreign key into the child

a.) all primary keys are unique

b.) the primary key may be null

a.) primary

b.) super

b.) entities

c.) objects

f) Entity

g) Recursive

Cust_ID  Name, Salesperson, Region

Salesperson  Region

d.) BCNF

44) What is the transitive dependency in this relation?

Attribute)

45) If this relation was in 3NF, the relational model is this database would look like:

g.) Sales (Cust_ID, Name, Salesperson)

Salesperson (Name, Region)

c.) anomalies

d.) normalization

Student_ID, Staff_ID  Class_Code, Enroll_Grade

Class_Code  Staff_ID

candidate key.

48) If this E/R model were converted to a relational model, the total number of relations

N N

a.) 1

49) Given the functional dependencies (A, B  C, D and C  B), what normal form is this

relation in?

50). Given the following functional dependencies, what normal form is this relation in?

Customer (A, B, C, D)

b.) 3NF(The condition C determines B causes the table to fail to meet the

BCNF requirement. Not every determinant is a candidate key. The converted BCNF