Answer ANY THREE questi (a) Database is defined as organized collection of logically related data Explain "Logically Related with two instances of the entity student. [10 marks (6) Data is raw facts. Discuss whether this definition of data is appropriate or not. [10] 02 State and explain with examples bow data can be made meaningful 201 03. Assuming the name is Client. Answer the following questions FirstName LastName Type Dahlia Landon Office Dahlia Landon Mobile Dahlia Landon Horne Mark Tristener Office Mark Tristener Emergency Jennifer Veladoner Mobile Jennifer Veladoner Office Jonathan Perfington Office Phone 510) 555.9821 650) 555-8103 850 555.9681 510) 555-5827 510) 555-3218 (415) 555-1496 510) 555-1039 (SO) SS5.5418 1) Write SQL statement to do the following a) Select all types of phone for Dahlia b) Select Client with last name Tristener c) Select the Client with the phone number (650)555-5438 d) Delete the record Mack from the table e) Delete the record Jonathan from the table m) Write SQL statement to create the table. [10 murk! 4. Emerging Electric wishes to create a database with the following entities and tribute Customer , with attributes Customer ID. Name, Address Street. Cay State Zip Code), and Telephone Location with attributes Location ID. Address (Steret. City State Zip Coded Type(values of Business or Residential Rate, with attributes Rate Class and Rate Per KWH After interviews with the owners, you have come up with the following bonnes rules DC: ACDON-F004 Customers can have one or more locations Each location can have one or more rites, depending on the time of day Draw an ERD for this situation and place minimum and maximum candinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course. State any assumptions that you have made Answer ANY THREE questi (a) Database is defined as organized collection of logically related data Explain "Logically Related with two instances of the entity student. [10 marks (6) Data is raw facts. Discuss whether this definition of data is appropriate or not. [10] 02 State and explain with examples bow data can be made meaningful 201 03. Assuming the name is Client. Answer the following questions FirstName LastName Type Dahlia Landon Office Dahlia Landon Mobile Dahlia Landon Horne Mark Tristener Office Mark Tristener Emergency Jennifer Veladoner Mobile Jennifer Veladoner Office Jonathan Perfington Office Phone 510) 555.9821 650) 555-8103 850 555.9681 510) 555-5827 510) 555-3218 (415) 555-1496 510) 555-1039 (SO) SS5.5418 1) Write SQL statement to do the following a) Select all types of phone for Dahlia b) Select Client with last name Tristener c) Select the Client with the phone number (650)555-5438 d) Delete the record Mack from the table e) Delete the record Jonathan from the table m) Write SQL statement to create the table. [10 murk! 4. Emerging Electric wishes to create a database with the following entities and tribute Customer , with attributes Customer ID. Name, Address Street. Cay State Zip Code), and Telephone Location with attributes Location ID. Address (Steret. City State Zip Coded Type(values of Business or Residential Rate, with attributes Rate Class and Rate Per KWH After interviews with the owners, you have come up with the following bonnes rules DC: ACDON-F004 Customers can have one or more locations Each location can have one or more rites, depending on the time of day Draw an ERD for this situation and place minimum and maximum candinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course. State any assumptions that you have made
