View the step-by-step solution to:

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...

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

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question