You take a summer job working for a small book store, SmallBooks, which wants to expand its business model to include online sales and to keep track of its employee's details. To do this SmallBooks needs a database. SmallBooks contracts an IT business, IT Local, to build and maintain the required database. IT Local assigns a Project Manager, Alex, to oversee the work. However, IT Local does not have any specific knowledge about SmallBooks. To help fill this gap, you are asked to be part of the Project Team. Your role is to assist in planning the database. The IT Local team has been working on planning the necessary relations for the SmallBooks relational database. Alex has determined that SmallBooks has three department's accounts, stores and sales. Each employee works in just one department. Each department has just one manager. Keeping track of tax will not be part of the database. 1. At the first meeting the Alex explains that a relational database will provide the best model for SmallBooks. Explain briefly why the relational model is appropriate. 2. A suitable name for the database must be chosen. Someone suggests BOOKS. Why is this not a good name? Suggest a suitable name. 3. Alex needs to know some of the queries that will be requested by staff using the database. State (in plain English) three such queries. 4. Alex reports at the next meeting that relation is EMPLOYEE will be required. Remember, we are working in relational algebra, so the data are only possible examples
EMPLOYEE ENAME DEPT_NO J. Smith D1 J. Smith D1 R. Brown D2 M. Green D3
Recently Asked Questions
- What type of approach do sgt. Evans and Lee the intern take in solving the issue of the robbery attempts on a targeted ATM?
- In regards to the interaction of the hypothalamus and the pituitary gland , which of the following is TRUE ?
- The figure above reveals a typical growth curve for a bacterial culture . This type of growth we would call _______________ growth .