ISOM 3260 - Database Design and Administration
Midterm Exam Practice Questions

To access the review, press here.

To access the suggested solution, press here.

Section 1A - Basic Terminology in Databases

Question 1 - Which of the following is NOT a type of structured data?
A. Text
B. Number
C. Date
D. Image

Question 2 - The difference between data and information is that
A. data is organised and meaningful to decision making.
B. data is unorganised and meaningful to decision making.
C. information is organised and meaningful to decision making.
D. informaiton is unorganised and meaningful to decision making.

Question 3 - Which of the following would NOT be an example of metadata?
A. Student ID Number
B. The description of the field
C. The datatype of the field
D. The index of the data

Question 4 - Which of the following is NOT a function of a database management system?
A. Data Storage
B. Data Presentation
C. Data Retrivial
D. Data Update

Question 5 - Which of the following is NOT an advantage of adopting a database approach in an information system?
A. Allow Data Sharing
B. Increase Data Redundancy
C. Enforce Standards
D. Improved Data Quality

Question 6 - Which of the following database technologies is NOT under active development?
A. Flat Files
B. Object-oriented
C. Object-relational
D. Data Warehousing

Question 7 - Which of the following best describes the typical size of an enterprise resource planning system?
A. Kilobytes
B. Megabytes
C. Gigabytes
D. Petabytes

Question 8 - The metadata of a database is stored in __________.
A. Computer-Aided Software Engineering (CASE) Tools
B. DBMS
C. Application Programme
D. Repository

Question 9 - Which of the following software vendor holds the largest revenue share in database development, as of October 2018?
A. Microsoft
B. Oracle
C. IBM
D. SAP

Question 10 - Logical Data Modeling belongs to the __________ stage of a typical SDLC cycle.
A. Planning
B. Analysing
C. Designing
D. Implementing

Section 1B - Open Source Databases

Question 1 - Concerning open source software, which of the following is NOT correct?
A. Open source software is typically developed by many people.
B. Open source software is always free.
C. The source code of an open source software is obtainable.
D. Open source software is a good choice for companies with financial constraints.

Question 2 - Which of the following is NOT a benefit of using an open source database?
A. The company can save implementation costs.
B. The company does not need a large upfront investment for an open source database management system.
C. The company can save implementation time.
D. The company can avoid technical risks, compared to commercial database.

Question 3 - Which of the following is NOT an open source database?
A. MySQL
B. Redis
C. ElasticSearch
D. IBM Db2

Section 2 - Conceptual Database Design with Entity-Relationship Diagram

Question 1

For each of (a) to (f), identify the relationship between entities and draw a simplified ER Diagram. Show the relationship name and all cardinality constraints. Omit the attributes of all entity types. You may choose not to convert any binary many-to-many relationship into its associative form.

(a) Each department head (HEAD) supervises one and only one department (DEPARTMENT). Each department is supervised by one and only one department head.

(b) Each model of cars (MODEL) belongs to one manufacturer (MANUFACTURER). Each manufacturer must have one or more car models.

(c) Each student (STUDENT) can enroll to many courses (COURSE). Each course may many students.

(d) Some employee (EMPLOYEE) may supervise one or more other employee. Each employee may be supervised by at most one other employee. Each employee must be assigned to one and only one project (PROJECT). Each project must have more than one employee.

(e) Each professor (PROFESSOR) must belong to one or more departments (DEPARTMENT). Each department must have one or more professors. Amongst the professor assigned, one may supervise the department. Each department may be supervised by at most one professor. Each professor may supervise only one department.

(f) Each bus driver (BUS_DRIVER) must be trained on one or more bus types (BUS_TYPE) to serve on one or more routes (ROUTE). There may be some routes or bus types which no driver has trained on.

Question 2

For the following scenario, draw a conceptual ER Diagram, showing all entities, attributes, relationships, and cardinality constraints. Make necessary assumptions whenever appropriate. You must convert any binary many-to-many relationship into its associative form.

Ash is an IT technician in a secondary school. Recently, he is required to build a system to store information regarding the upcoming Athletic’s Meet. The following is the business rules:

Question 3

For the following scenario, draw a conceptual ER Diagram, showing all entities, attributes, relationships, and cardinality constraints. Make necessary assumptions whenever appropriate. You must convert any binary many-to-many relationship into its associative form.

Bob is going to design a library system for a clubhouse. The main goal of this system is to allow members of the clubhouse to borrow books and magazines. The following is the business rules:

Section 3 - Conceptual Database Design with Enhanced Entity-Relationship Diagram

Question 3-31

For the following scenario, draw a conceptual Enhanced ER Diagram, showing all entities, attributes, subtype discriminators, relationships, cardinality constraints, completeness constraints, and disjoint constraints. Make necessary assumptions whenever appropriate. You must convert any binary many-to-many relationship into its associative form.

A technology company provides offerings to its customers. Offerings are of two separate types: products and services. Offerings are identified by an offering ID and an attribute of description. In addition, products are described by product name, standard price, and date of first release; services are described by name of the company’s unit responsible for the service and conditions of service. There are repair, maintenance, and other types of services. A repair service has a cost and is the repair of some product; a maintenance service has an hourly rate. Fortunately, some products never require repair. However, there are many potential repair services for a product. A customer may purchase an offering, and the company needs to keep track of when the offering was purchased and the contact person for that offering with the customer. Unfortunately, not all offerings are purchased. Customers are identified by customer ID and have descriptive data of name, address, and phone number. When a service is performed, that service is billed to some customer. Because some customers purchase offerings for their clients, a customer may be billed for services he or she did not purchase, as well as for ones that were purchased. When a customer is billed for a service (although some may never require a service of any type), the company needs to keep track of the date the service was performed, the date the bill is due, and the amount due.

Question 3-33

For the following scenario, draw a conceptual Enhanced ER Diagram, showing all entities, attributes, subtype discriminators, relationships, cardinality constraints, completeness constraints, and disjoint constraints. Make necessary assumptions whenever appropriate.

An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules:

After some further discussions, you have come up with some additional business rules to help you create the initial design: