Tables in Database:
Lab1_Employee,
Lab1_Owner,
Lab1_PercentOwned,
Lab1_Properties,
Lab1_SalesOffice
Please provide these six queries based on the tables above:
a. Query all owners in the Lab1_Owners Table
b. Query all SalesOffices in CA
c. Query all properties in DC
d. Query all properties along with the sales manager responsible for the SalesOffice that sold the Properties
e. Query Percent Owned table to determine who owns 100% of a property
f. What Owner is serviced by what Office Manager? (Four Table Join!)
Answer these 3 questions:
a. What are entity and referential integrity? (100-150 words)
b. Why are entity and referential integrity important in a database? (100 words)
3. Can you describe what are 1NF, 2NF and 3NF normalization in DB? (100 words)