DBST 651 Midterm Exam
DBST 651 Midterm Exam
Copy and Pate below link into your Browser to buy tutorial
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