DBST 651 MIDTERM EXAM


To Download tutorial Copy and Paste below Link into your Browser
https://www.essayblue.com/downloads/dbst-651-midterm-exam/?ref=183

for any inquiry email us at  ( essayblue@gmail.com )

DBST 651 Midterm Exam

1.     A(n) ____ enables a database administrator to define schema components.
2.     extensible markup language (XML)
3.     query language
4.     data definition language (DDL)
5.     unified modeling language (UML)

  • ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
1.     A) Queries
2.     B) Metadata
3.     C) End-user data
4.     D) Information

  • Which of the following is a characteristic of databases?
1.     A) Many users can use the same database at the same time
2.     B) Different database entities can be connected to provide more information
3.     C) Relevant business data are stored in a database
4.     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:
5.     A) The bonus calculation program
6.     B) The personnel promotion application program
7.     C) The payroll application program
8.     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:
6.     A) Nonprocedural programming
7.     B) Transaction processing
8.     C) Data independence
9.     D) Data sharing


6.     Entity Relationship Diagrams are input to the following phase of Database Development:
7.     A) Logical Database Design
8.     B) Conceptual Data Modeling
9.     C) Physical Database Design
10.  D) Distributed Database Design



7.     Which of the following is independent of the choice of a DBMS?
8.     A) Entity Relationship Diagrams
9.     B) Distribution Schema
10.  C) Internal Schema
11.  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?
9.     A) Deptno
10.  B) Deptname
11.  C) Deptcity
12.  D) Deptmgr


9.     Which of the following columns is not a foreign key?
10.  A) Projno in table Project
11.  B) Projmgr in table Project
12.  C) Prstno in table Projstaff
13.  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:
11.  A) A violation of the entity integrity rule
12.  B) A violation of the referential integrity rule
13.  C) A violation of the entity integrity rule and of the referential integrity rule
14.  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?
12.  A) An md may be an administrator
13.  B) An RN may be an administrator
14.  C) An md may not be an administrator
15.  D) An md may be an RN

12.  Which of the following statements is true?
13.  A) A staff may exist that is neither an RN, nor an administrator, nor an md
14.  B) Every staff is either an RN, an administrator, or an md
15.  C) A staff may exist that is an RN and an administrator
16.  D) A staff may exist that is an administrator and an md

13.  The number of administrators is:
14.  A) Always the same as the number of departments
15.  B) Always smaller than the number of departments
16.  C) Smaller than or equal to the number of departments
17.  D) Larger than or equal to the number of departments
18.  In reviewing an ERD for consistency, the property of uniqueness applies to:
19.  A) Entity type names
20.  B) Attribute names within entity types and relationships
21.  C) Attribute names in a subtype
22.  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.
16.  A) Relations
17.  B) Indexes
18.  C) Keys
19.  D) Logical structures

16.  When constructing an ERD from a problem narrative:
17.  A) You can derive relationships but not cardinalities from the narrative
18.  B) You can derive cardinalities but not relationships from the narrative
19.  C) You can usually derive both relationships and cardinalities from the narrative, but sometimes they are incomplete
20.  D) None of the above

17.  Redundant relationships in a database design:
18.  A) Can be derived from other relationships
19.  B) Cannot be identified by reviewing the ERD
20.  C) Should always be removed from the database design
21.  D) None of the above

18.  The ____ relationship should be rare in any relational database design.
19.  A) M:N
20.  B) 1:M
21.  C) M:1
22.  D) 1:1

19.  Primary keys for entity types:
20.  A) Can be automatically generated by a DBMS
21.  B) Should be single purpose
22.  C) Are sometimes determined by industry or organizational practice
23.  D) All of the above

20.  Design documentation:
21.  A) Should explain subtle design decisions
22.  B) Should describe incompleteness and inconsistency in specification requirements
23.  C) Should communicate the database design to other interested parties throughout the lifetime of the database
24.  D) All of the above

1.      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.
1.     A) Surrogate primary keys
2.     B) time-variant data
3.     C) Design trap
4.     D) Fan trap


22.  Attributes may share a ____.
23.  A) Domain
24.  B) Name
25.  C) Location
26.  D) Column


1.     When designing a database, you should ____.
1.     A) Make sure entities are in normal form before table structures are created
2.     B) Create table structures then normalize the database
3.     C) Only normalize the database when performance problems occur
4.     D) Consider more important issues such as performance before normalizing


24.  The following step occurs first in the process of building an ERD: ____.
25.  A) Develop the initial ERD.
26.  B) Identify the business rules based on the description of operations.
27.  C) Identify the attributes and primary keys that adequately describe the entities.
28.  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 ____.
26.  A) Weak
27.  B) Strong
28.  C) Neutral
29.  D) Missing


DBST 651

 MIDTERM PART II



Name:                                                             Date:

Question 1:
The table shown below lists dentist-patient appointment data.  A patient is given an appointment at a specific time and date with a dentist located at a particular surgery.  On each day of patient appointments, a dentist is allocated to a specific surgery for that day.

StaffNo
Dentist Name
PatNo
PatName
Appointment Date & Time
SurgeryNo
S1011S1011
S1024
S1024
S1032
S1032
James BondJames Bond
Andrew Joe
Andrew Joe
Kevin King
Kevin King
P100P105
P108
P108
P107
P110
Kim Su Jenny Gold
Ian Chappell
Ian Chappell
John Spooner
Frank Holey
1/9/05 10.001/9/05 12.00
1/9/05 10.00
2/7/05 14.00
2/7/05 16.30
2/7/05 18.00
S10S15
S10
S10
S15
S13


Evaluate if the table shown above is normalized, if not describe and illustrate the process of normalizing the table shown above to third normal form.  State any assumptions you make about the data shown in this table. (15 Points)

Question 2:
Please provide answers to problems 17 through 23 in Chapter 3 of Coronel book page 110. (10th edition page 101-102)  (20 Points)

Question 3:
Please provide answers to problem 5 in Chapter 6 of Coronel book page 227. (10th edition page 217)  (15 Points)


Comments

Post a Comment