ISYS 464, Section 3, Fall, 2014 (Beckman): Exam #1 1
Answer 10 questions total ; 2 on each page plus any other 2. Print your name on the back of the last sheet. Give four examples of meta-data for the data item value “ISYS 464”. What is a file processing system? Describe (don’t just list) two disadvantages of the database approach. What is the difference between an enterprise data model and a project-level data model? What is the difference between a relationship instance and a relationship type? Give one example of each.
On an ER diagram, how would you represent a zero-to-zero (0:0) cardinality ratio between two entity types? Use only the ER diagram on page 5 of the exam to answer any of the next 2 questions. Does a patient have to have an order? Does an order have to have a patient? Draw the specific parts of the ER diagram that confirm your answers. To create an order, what directly-connected entity types are required ? To create an order, what directly- connected entity types are not required? Draw the specific parts of the ER diagram that confirm your answers.
You've reached the end of your free preview.
Want to read all 7 pages?
- Summer '19
- Business, Entity-relationship model, consultant, technical consultant