Relational Database Conversion Question A mid-sized retaile…
Relational Database Conversion Question A mid-sized retailer currently stores data in separate flat files (Excel/CSV): Employees.csv (EmployeeID, Name, Title, PayRate, SSN, HomeAddress) Customers.csv (CustID, Name, CreditLimit, PaymentTerms, Status) Sales.csv (SaleID, CustID, EmployeeID, Date, Amount) Management plans to convert to a relational database system. HR wants to ensure sensitive employee data (SSN, PayRate, HomeAddress) are protected.Accounting wants to ensure that salespeople cannot modify customer credit limits or payment terms. Which of the following BEST describes a key benefit of converting to a relational database in this scenario?
Read Details