Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise 2 - A UNIVERSITY A university consists of several faculties. Within each faculty there are several departments. Each department may run a number of
Exercise 2 - A UNIVERSITY A university consists of several faculties. Within each faculty there are several departments. Each department may run a number of courses. All teaching staff is attached to departments, each staff member belonging to a unique department. (Note: see how many meanings you can assign to this ambiguous sentence). Every course is composed of sub-courses. Some sub-courses are part of more than one course. Staff may teach on many sub-courses and each sub-course may be taught by a number of staff. Draw an entity-relationship model for this example. Show both cardinalities and optionalities. Put a question mark where the degree is not clear from the text. Don't assume anything; rather, write a list of questions you would have to find answers to in order to complete the model. Exercise 3 - SALES LEDGER AND STOCK CONTROL ABC Ltd plans to computerize its sales ordering and stock control system. A feasibility study has strongly suggested that a relational database system be installed. The details of ABC 's sales and stock control are as follows: Customers send in orders for goods. Each order may contain requests for variable quantities of one or more products from ABC s range. ABC keeps a stock file showing for each product the product details and the preferred supplier, the quantity in stock, the reorder level and other details. ABC delivers those goods that it has in stock in response to the customer order and an invoice is produced for the dispatched items. Any items that were not in stock are placed on a back order list and these items are usually re-ordered from the preferred supplier. Occasionally items are ordered from alternative sources. In response to the invoices that are sent out to ABC 's customers, the customers send in payments. Sometimes a payment will be for one invoice, sometimes for part of an invoice and sometimes for several invoices and part-invoices
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started