DBST 651 

 

MIDTERM PART I

 

 

1. Midterm exam is dueSundayby 11:59 pm EST.

 

2. Late submission - 10% penalty per day will be applied up to five days. After these five days zero credit will be given.

 

3. This is an online (take-home) exam, please do not interact or collaborate with class members while completing this exam.

 

4. Your responses should be submitted as twoword documents with filename including your first initial of your first name and last name formatted – example SBishopMidterm_part1.doc and SBishopMidterm_part2.doc.

 

5. Submissions: please post the files as an attachment in assignment folder for midterm exam.Please don’t forget to sign the Honor Pledge.

 

6. The midterm exam is in two parts: Multiple Choice (50 Points) and Hands-on (50 points)

 

7. Please use the response sheet below for Part I.

THESE QUESTIONS AND YOUR RESPONSES MAY NOT BE SHARED OR DISTRIBUTED IN ANY FORM.  SUCH DISTRIBUTION WILL CONSTITUTE A VIOLATION OF ACADEMIC INTEGRITY.

Please sign (typing your name is fine) the following statement

Independent Work Statement

 

 

 

Midterm Part I: Response Sheet

 

 

 

 

 

 

 

MIDTERM PART I

 

1.A(n) __C__ enables a database administrator to define schema components.

A)    extensible markup language (XML)

B)    query language

C)    data definition language (DDL)

D)    unified modeling language (UML)

 

2.__B__ defines(s) and describes the data and relationships between tables in the database.

            A)  Queries

            B)   Metadata

            C)   End-user data

            D)  Information

 

3.Which of the following is a characteristic of databases? D

            A)  Many users can use the same database at the same time

            B)   Data redundancy control

            C)   Multiple data views. Each view contains only the data that a user/users group needs to access.

            D)  All of the above

 

Use the following to answer questions 4 - 5:

 

A database table consists of the following columns: employee's name, SS#, job-title, hiring-date, years-in-job, base-salary.  A bonus calculation program, a personnel promotion application program, and a payroll application program all use this table.  To implement a policy change in personnel promotion, the following column is added to the table: highest-college-degree. This new column is not used by the payroll program or by the bonus calculation program.

 

4.The following application program will be modified to accommodate the change to the database table: C

            A)  The bonus calculation program

            B)   The payroll application program

            C)   The personnel promotion application program

            D)  All of the above

 

5.The ability to add the new column without requiring changes to all of the application programs strongly relates to the following feature of modern database systems: D

            A)  Nonprocedural programming

            B)   Transaction processing

            C)   Data sharing

            D)  Data independence

 

 

6.Entity Relationship Diagrams are input to the following phase of Database Development: A

            A)  Logical Database Design

            B)   Conceptual Data Modeling

            C)   Physical Database Design

            D)  Distributed Database Design

 

 

 

7.Which of the following is independent of the choice of a DBMS? A

            A)  Entity Relationship Diagrams

            B)   Distribution Schema

            C)   Internal Schema

            D)  Index files

 

 

Use the following to answer questions 8 - 10:

 

In the table Employee, each row contains data about an employee. The primary key is Empno. The attribute Empdeptno is a foreign key referring to the department number (Deptno. of the table Department.

 

 

The combination of columns Prstno, Prstempno is a candidate key. There could be other candidate keys. Prstempno is the Empno in table Employee of the employee working on project number Prstno, which refers to Projno in the table Project. The meaning of Prstasgtno is left undefined.

 

 

8.Which of the following columns of the table Department is a foreign key? A

            A)  Deptmgr

            B)   Deptname

            C)   Deptcity

            D)  Deptno

 

 

9.Which of the following columns is not a foreign key? C

            A)  Prstno in table Projstaff

            B)   Projmgr in table Project

            C)   Projno in table Project

            D)  Prstempno in table Projstaff

 

 

 

10.  If the combination Prstno, Prstempno is chosen as the primary key for table Projstaff, setting Prstno to null in some row would be: B

            A)  A violation of the referential integrity rule

            B)   A violation of the entity integrity rule

            C)   A violation of the entity integrity rule and of the referential integrity rule

            D)  None of the above

 

Use the following to answer questions 11 – 13 (Disjoint and Partial completeness):

 

 

 

11.  Which of the following statements is true? D

            A)  An md may be an administrator

            B)   An RN may be an administrator

            C)   An md may be an RN

            D)  An md may not be an administrator

 

12.  Which of the following statements is true? A

            A)  A staff may exist that is neither an RN, nor an administrator, nor an md

            B)   Every staff is either an RN, an administrator, or an md

            C)   A staff may exist that is an RN and an administrator

            D)  A staff may exist that is an administrator and an md

 

13.  The number of administrators is: B

            A)  Always the same as the number of departments

            B)   Smaller than or equal to the number of departments

            C)   Always smaller than the number of departments

            D)  Larger than or equal to the number of departments

 

14.  In reviewing an ERD for consistency, the property of uniqueness applies to: D

            A)  Entity type names

            B)   Attribute names within entity types and relationships

            C)   Attribute names in a subtype

            D)  All of the above

 

15.  In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable. C

            A) Relations

            B) Indexes

            C) Keys

            D) Logical structures

                                               

16.  When constructing an ERD from a problem narrative: C

            A)  You can derive relationships but not cardinalities from the narrative

            B)   You can derive cardinalities but not relationships from the narrative

            C)   You can usually derive both relationships and cardinalities from the narrative, but sometimes they are incomplete

            D)  None of the above

 

17.  Redundant relationships in a database design: A

            A)  Can be derived from other relationships

            B)   Cannot be identified by reviewing the ERD

            C)   Should always be removed from the database design

            D)  None of the above

 

18.  The ____ relationship should be rare in any relational database design. B

            A) M:N

            B) 1:1

            C) M:1

            D)1:M

           

19.  Primary keys for entity types: D

            A)  Can be automatically generated by a DBMS

            B)   Uniquely identify an instance

            C)   Values do not change over time

            D)  All of the above

 

20.  Design documentation: D

            A)  Should explain subtle design decisions

            B)   Should describe incompleteness and inconsistency in specification requirements

            C)   Should communicate the database design to other interested parties throughout the lifetime of the database

            D)  All of the above

 

21. A ____ occurs when you have one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model.C

A) Surrogate primary keys                 

B) time-variant data   

C) Fan trap

D) Design trap

           

 

22.  Attributes may share a ____. B

            A) Name

            B) Domain

            C) Location

            D) Column

 

 

23. When designing a database, you should ____. B

A) Create table structures then normalize the database         

B)Make sure entities are in normal form before table structures are created 

C) Only normalize the database when performance problems occur 

D) Consider more important issues such as performance before normalizing

        

 

24.  The following step occurs first in the process of building an ERD: ____.D

            A) Develop the initial ERD.

            B)Identify the business rules based on the description of operations.

            C) Identify the attributes and primary keys that adequately describe the entities.

            D) Create a detailed narrative of the organization’s description of operations.

                                   

 

25.  When the PK of one entity does not contain the PK of a related entity, the relationship is ____.A

            A) Weak

            B) Strong

            C) Neutral

            D) Missing