1. In the General Hardware Corp. relational database as shown in Figure 4.1 (pp. 71–72) above: a. How many foreign keys are there in each of the six relations?
Answer 1a: There are between three and six foreign keys in each of the six relations.
b. List the foreign keys in each of the six relations.
Answer 1b: Starting from top left and continuing down, they are Salesperson Number, Salesperson Name, Commission Percentage, Year of Hire, Office Number; Customer Number, Customer Note, Salesperson Number, HQ City; Customer Number, Employee Number, Employee Name, Title; Product Number, Product Name, Unit Price; Salesperson Number, Product Number, Quantity; Office…show more content… f. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-to-null and an attempt is made to delete the record for employee 33779 of customer 2198 in the
CUSTOMER EMPLOYEE relation?
Answer 4f:
If the delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-to-null and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPOYEE relation, it will get deleted and also no record will be deleted in referencing CUSTOMER relation.
5. Identify and explain the major difficulties involved in managing data. Answer 5:
The major difficulties involved in managing the data are:
Data Integrity: Data integrity is also the major difficulty in managing the data. Mainly the transactional data which involves large number of transaction with critical data has chances of losing data…show more content… Define data governance and explain why it is necessary.
Answer 6:
Data governance is the overall management of security, availability, usability and integrity of data. It usually consists of some governing body that defines certain set of rules and procedures and executes those procedures properly.
It is necessary because of the following reasons: o It helps to get consistent and reliable data. Data governance provides proper documents and procedures throughout the organization so it makes the data consistent and reliable. o It also saves money by negotiating in different activities with certain organizations for costing things. o It guides all the analytical activities. It also finds that who is responsible for different parts of analytics.
7. Compare and contrast master data and transactional data, and provide an example of each one.
Answer 7:
Transactional Data: Transactional data is the information that is encoded during any transaction or process. It is the data which describes the events of business. Transactional data is highly volatile, it changes frequently.
For example, in an ERP system, it can include data related to sales, invoices, and other
