Mid-Term Review-Questions
pdf
keyboard_arrow_up
School
Binghamton University *
*We aren’t endorsed by this school
Course
333
Subject
Information Systems
Date
Apr 3, 2024
Type
Pages
7
Uploaded by laurenwexler3
1 Database Management Systems Midterm Exam – Review TRUE OR FALSE Questions (Each 1 point) 1.
Prototyping is a type of rapid application development. 2.
Database maintenance is typically the longest step of the database development process. 3.
Database development begins with the design of the database. 4.
Personal databases are designed to support a small group of individuals working together on a project. 5.
The user interface includes languages, menus, and other facilities by which users interact with various system components. 6.
Cost and complexity are just two of the disadvantages of database processing. 7.
The term legacy system refers to a newly installed database management system.
8.
Data redundancy is used to establish relationships between data but is never used to improve database performance.
9.
Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.
10.
For the relationship represented in the figure below, a department can have more than one employee. 11. In the figure shown below, a person has to be married.
2 12.
An attribute whose values can be calculated from related attribute values is called a derived attribute. 13.
In an E-R diagram, strong entities are represented by double-walled rectangles.
14.
A business rule is a statement of how a policy is enforced or conducted.
15.
One of the roles of a database analyst is to identify and understand rules that govern data. Multiple Choice Questions (Each 1 point) 16. A property or characteristic of an entity type that is of interest to the organization is called a(n): A) attribute. B) coexisting entity. C) relationship. D) cross-function. 17. A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. A) degree B) cardinality constraint C) counter constraint D) limit 18. A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship. A) optional B) unidirectional C) mandatory link D) mandatory one 19. In the figure below, which attribute is derived? A) Years_Employed B) Employee_ID
3 C) Skill D) Address 20. A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. A) one-to-one B) many-to-many C) one-to-many D) strong 21. Which of the following criteria should be considered when selecting an identifier? A) Choose an identifier that is not stable. B) Choose a null identifier. C) Choose an identifier that doesn't have large composite attributes. D) Choose the most complex identifier possible. 22. An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n): A) composite attribute. B) composite identifier. C) identifying attribute. D) relationship identifier. 23. The total quiz points for a student for an entire semester is a(n) ________ attribute. A) derived B) mixed C) stored D) addressed 24. Customers, cars, and parts are examples of: A) entities. B) attributes. C) cardinals. D) relationships.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4 Short Answers (Each 5 Points) 25.
What is the difference between an entity type and an entity instance? In the context of a COVID-19 vaccination tracking database, give two examples of an entity type and the corresponding entity instance. 26.
What are the three different degrees of relationship? Describe each in one line. Provide examples. 27.
Discuss Enterprise Resource Planning Systems, and contrast these to data warehouses.
5 28.
Discuss some of the disadvantages of file processing systems. 29. List some of the costs associated with the database approach. 30.
In the following data model, the entity PRODUCT has two attributes Product ID (primary key) and Product Name. The entity ITEM has three attributes Item ID (Primary Key), Product ID (foreign key), and Item Name. The following tables represent how data is physically stored in a database for the data model presented above. PRODUCT ITEM Product ID Product Name Item ID Item Name Product ID 1 Computer 1 Keyboard 1 2 Car 2 Mouse 1 3 Laptop 3 Monitor 1 4 Window 2 5 Tires NULL 6 Engine 2 7 Steering Wheel 2 Do you think that the business rules shown in the data model are enforced correctly in the two tables above? Say Yes or No. Justify your answer. PRODUCT ITEM
6 Long Answer (10 Points) 31.
The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their parents. Also, data needs to be kept on the coaches for each team. Draw the data model described below, making sure your model resolves any implementation issues you might come across. - Entities required: Team, Player, Coach, and Parent. - Attributes required: + Team: Team ID number, Team name, and Team colors. + Player: Player ID number, Player first name, Player last name, and Player age. + Coach: Coach ID number, Coach first name, Coach last name, and Coach home phone number. + Parent: Parent ID number, Parent last name, Parent first name, Home phone number, and Home Address (Street, City, State, and ZIP Code). The following relationships must be defined: •
Team is related to Player. •
Team is related to Coach. •
Player is related to Parent. Cardinality constraints are defined as follows: •
A Team may or may not have a Player. •
A Player must have a Team. •
A Team may have many Players. •
A Player has only one Team. •
A Team may or may not have a Coach. •
A Coach must have a Team. •
A Team may have many Coaches. •
A Coach has only one Team. •
A Player must have a Parent. •
A Parent must have a Player. •
A Player may have many Parents. •
A Parent may have many Players.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7