Question: Give an SQL schema definition for the employee database of
Give an SQL schema definition for the employee database of Figure. Choose an appropriate domain for each attribute and an appropriate primary key for each relationschema.
Answer to relevant QuestionsWrite check conditions for the schema you defined in Exercise 4.14 to ensure that:a. Every employee works for a company located in the same city as the city in which the employee lives.b. No employee earns a salary higher ...Consider the relational database of Figure. Give expressions in QBE for each of the following queries:a. Modify the database so that Jones now lives in Newtown.b. Give all employees of First Bank Corporation a 10 percent ...Complete the SQL DDL definition of the bank database of Figure to include the relations loan andborrower.Make a list of security concerns for a bank. For each item on your list, state whether this concern relates to physical security, human security, operatingsystem security, or database security.Suppose that we decompose the schema R = (A, B, C, D, E) into (A, B, C) (A, D, E). Show that this decomposition is a loss less-join decomposition if the following set F of functional dependencies holds: A → BC CD ...
Post your question