Review Questions

1.Draw functional dependency (FD) diagram for retail banking case study discussed in Section 22.2.
2.M/s KLY Computer System and Services is in the business of computer assembly and retailing. It assembles personal computers (PCs) and sales to its customers. To remain competitive in the computer segment and provide its customers the best deals, M/s KLY has decided to implement a computerised manufacturing and sales system. The requirement definition and analysis is given below:

Requirement Definition and Analysis

M/s KLY computer system and services has the following main processes:

  • Marketing.

  • PC assembly.

  • Finished goods warehouse.

  • Sales and delivery.

  • Finance.

  • Purchase and stores.

The following requirements have been identifies after ...

Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.