4.0 Data Base Management Exercise

4.1 Design a Database Architecture for Your Company "

4.2 Decide The Files The Entities (Entity Set) The Attributes of the Entities The Key Fields of Each Record

4.3 Requirements for the Company Database (Identify the Requirements ) The company is organized into Departments. Each department has a name, number, and an employee who manages the department. We keep track of the start date if the department has a manager. A department may have several locations. Each department controls a number of Projects. Each project has a name, number, and is located at a single location. We store each Employees social security number, name, addresses, salary, sex, and birth date. Each employee works for one department but may work on several projects. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of Dependents. For each dependent, we keep their name, sex, birthdate, and relationship to the employee. Draw the ER Model for Company Database

4.4 Mr. Alexandra, the manager of KIMEP Book Store (KBS), decides to computerize KBSs Books Ordering and stock control system. A feasibility study has strongly suggested that a relational database system be installed. The details of KBS's Books procurement and stock control are as follows: Professors of IM often send Requisitions-for-Text-Books for their courses roughly two months before the beginning of their course. Each professor may send Zero, one or many requisitions. Each requisition contains request(s) for variable quantities of one or more text books from various publishers. KBS keeps a stock file showing for each book, edition and its publisher, the quantity in stock, and then place Purchase-Order(s)-for Books for fresh stock, if required. On arrival of these books, KBS updates its stock and sale those books to the students and raise Invoice/ Bill-of-Purchase and collect Payments. KBS usually sales books on cash, but do offer maximum of two moths of credit on request and maintains records of Accounts-Receivables for each invoice. Generally publishers keep sufficient stock of books. The books that are out of stock are often placed on a back-order-list and often re-order them from alternative sources. A student may buy one or many books at a time and in response to the requirements of students, KBS prepare invoice and collect payments. Sometimes KBS receives payment for one invoice, several invoices or part-of an invoice. Notes: Invoice = Bill of Purchase a commercial term.

Use BNF, Production and Data Structure methods to describe the structure of the followings: A Professors Requisition for text Books B Requisition for Purchase C Invoice for the students

Develop the following doc. Invoice Order Placement Order Enquiry Product Enquiry Payment Delivery Sales Report