Database Dsgn & Implementation
please do this all the questions please!
Please write your name and student ID at the top of the word document Upload the document to Moodle 1) Draw data models for the following entities. In each case, make certain that you show the attributes and identifiers: a) Aireraft: An aireraft has a manufacturer, model number, call sign (e.g., N123D), payload, and a year of construction. Aircraft are classified as civilian or military. b) Car: A car has a manufacturer, range name, and style code (e.g., a Honda Accord DX, where Honda is the manufacturer, Accord is the range, and DX is the style). A car also has a vehicle identification code, registration code, and color. c) Restaurant: A restaurant has an address, seating capacity, phone number, and style of food (e.g., French, Russian, Chinese) d) Cow: A dairy cow has a name, date of birth, breed (e.g.4 Holstein), and a numbered plastic ear tag. 2) Take each of the entities you have modeled, create a relational database, and insert some rows. 3) Run the following queries and explain the differences in output. Write each query as a manager might state it. 4) Eduardo, a bibliophile, has a collection of several hundred books. Being a little disorganized, he has his books seattered around his den. They are piled on the floor, some are in bookeases, and others sit on top of his desk. Because he has so many books, he finds it difficult to remember what he has, and sometimes he cannot find the book he wants. Eduardo has a simple personal computer file system that is fine for a single entity or file. He has decided that he would like to list each book by author(s)' name and type of book (e.g4 literature, travel, reference). Draw a data model for this problem, create a single entity table, and write some SQL queries. a) How do you identify each instance of a book? (It might help to look at a few books.) 4) Eduardo, a bibliophile, has a collection of several hundred books. Being a little disorganized, he has his books scattered around his den. They are piled on the floor, some are in bookcases, and others sit on top of his desk. Because he has so many books, he finds it difficult to remember what he has, and sometimes he cannot find the book he wants. Eduardo has a simple personal computer file system that is fine for a single entity or file. He has decided that he would like to list each book by author(s)' name and type of book (e.g., literature, travel, reference). Draw a data model for this problem, create a single entity table, and write some SQL queries. a) How do you identify each instance of a book? (It might help to look at a few books.) b) Are there any shortcomings with the data model you have created? 5) What is the entity integrity rule? 6) What is the common name used to refer to systems that help organizations remember knowledge? 7) What is the relationship between data, information, and knowledge
