ISE_382_Midterm_Review_Answers

ISE_382_Midterm_Review_Answers - ISE 382 Midterm Review...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Midterm Review Questions (with answers) 1) What does DBMS stand for? DBMS stands for Database Management System 2 What is a data model? Why are such models important? A data model is a logical representation of the structure of the database. Data modeling is very important because the design of the database and all of its structures depend on the data model. If the data model is incorrect, the result will be waste, aggravation, delays, and frustration. New Whatcom Library Checkout List Name Card Number Book Due Date Joe Smith 123-450201 How To Garden 09/12/20xx Sara Jones 123-450217 Some Good Fiction 09/12/20xx Sam Archer 123-450326 How To Build Things 09/15/20xx Sam Archer 123-450326 More Good Fiction 09/15/20xx Joe Smith 123-450201 More How To Garden 09/17/20xx 3 Given the New Whatcom Library Checkout List shown above, if Sam Archer's card is lost and the card number shown must be replaced we must be careful to change each occurrence of the number or else we will have a a.) data inconsistency problem b.) data addition problem c.) data deletion problem d.) missing data problem e.) None of the above. New Whatcom Library Checkout List Name Card Number Book Due Date Joe Smith 123-450201 How To Garden 09/12/20xx Sara Jones 123-450217 Some Good Fiction 09/12/20xx Sam Archer 123-450326 How To Build Things 09/15/20xx Sam Archer 123-450326 More Good Fiction 09/15/20xx Joe Smith 123-450201 More How To Garden 09/17/20xx 4 Given the New Whatcom Library Checkout List shown above, if Some Good Fiction is lost and must be removed from the list, all information about Sara Jones will also be removed. This is an example of a . 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

ISE_382_Midterm_Review_Answers - ISE 382 Midterm Review...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online