Database Management HW 2

What is the best entity-relationship diagram to model students, dorms, rooms for student housing? A) Dorm -- (1:m) -- Room -- (1:m) -- Student B) Dorm -- (1:m) -- Room -- (m:m) -- Student C) Student -- (1:m) Dorm -- (1:m) -- Room D) Dorm -- (1:m) -- Student -- (m:1) -- Room

A

(check all that apply) Identify object relationships: Check all that justify a direct relationship between the two mentioned objects for airline reservation system? A) customers make reservations B) employees print boarding passes C) customers make payments D) passengers are assigned to airplane seats E) flights have desinations

ACE

(check all that apply) Identify object relationships: Check all that justify the connection between two mentioned objects for a student registration system? A) students takes classes B) instructors teach students C) students goes to classroom D) departments offer courses E) instructors belong to departments

ADE

(check all that apply) Identify objects for data modeling: Which of the following are objects for the problem domain of banking systems? A) ATMs, employees, branches, customers B) account balance, credit, debit, fraud C) customer service, help desk, customer satisfaction, validate accounts D) withdraws, transfers, depisits E) products, accounts, orders

ADE

(check all that apply) Identify object attributes: Which of the following are legitimate attributes of Shipments in an online order system? A) ship date B) check shipping status C) delivery address D) warehouse E) delivery date

AE

(check all that apply) Identify object attributes: Which of the following are legitimate attributes of Borrow in a college library system? A) book title B) borrower type C) overdue D) checkouts E) returns

B

Identify object relationships: A flight has a starting airport, a destination airport, and zero or more pass-over airports. How do you model the relationships between Flights and Airports A) create three different relationships respectively for starting, destination, and passover B) create a gerund between Flight and Airport and use an attribute to indicate starting, destination, and passover C) create one direct m:m relationship between Flights and Airports D) create a recursive relationship on Airports

B

(check all that apply) Identify objects for data modeling: Which of the following are objects for the problem domain of student registration? A) tuition, financial services, fees, credit hours, registrar B) students, courses, instructors, sections, classrooms C) advisers, departments, buildings, registrations D) registration time, class cap, class closed, payment due date E) textbooks, parents, university, registration system, print receipt

BC

Which is not a relevant feature of CASE tools? A) The ability to help draw data models using entity-relationship notations B) The ability to generate code C) An information repository D) Access to a DB via the internet

D

(check all that apply) Identify object relationships: Check all that justify a direct relationship between the two mentioned objects in each sentence for a point of sale system (POS)? A) cashiers checkout items B) managers balance inventories C) customer check price D) cashiers perform transactions E) employee handle returns

DE