Question: DATA BASE CLASS - A small library keeps a roster of who will be at the desk each day. They have a database table as

DATA BASE CLASS -

A small library keeps a roster of who will be at the desk each day. They have a database table as shown below.

Week Start___Mon___Tue____Wed_____Thur____Fri

17/10/2011 -- Jane -- Sue -- George -- Sue -- Jane

24/10/2011 -- Jane -- Sue -- Linda -- Sue -- Lee

31/10/2011 -- Sue -- Sue -- Lee -- George -- George

a) What problems can you foresee in making good use of this information?

b) Suggest some better ways that this information could be stored.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Exercise #1 : A small library keeps a roster of who will be at the desk each day. They have a database table as shown below. Week Start___Mon___Tue____Wed_____Thur____Fri 17/10/2011 -- Jane -- Sue --...

Q:

A small library keeps a roster of who will be at the desk each day. They have a database table as shown below. Week Start___Mon___Tue____Wed_____Thur____Fri 17/10/2011 -- Jane -- Sue -- George -- Sue...

Q:

Suggest some better ways that this information could be stored. Exercise 1-2 A small library keeps a roster of who will be at the desk each day. They have a database table as shown in Figure 1-8....

Q:

A small library keeps a roster of who will be at the desk each day. They have a database table as shown below.

Q:

Any help with this would be greatly appreciated! An HR Payroll System Computers are great at storing and manipulating data. For this project, you will write code that keeps track of Human Resources...

Q:

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Q:

Objectives Develop experience in working with a team. Review real world problems, and identify elements of decision-making, analyze the problem and its various elements, describe the theories used to...

Q:

Part 1 of the Final Project, due at the end of this unit, requires you to describe and draw a flowchart of the sales or purchasing process at your organization (or one of your choice). This...

Q:

Part 1 of the Final Project, due at the end of this unit, requires you to describe and draw a flowchart of the sales or purchasing process at your organization (or one of your choice). This...

Q:

E-1. Analyze the five interviews. In a paragraph, discuss what type of structure each interview has. E-2. List each interview, 1 through 5, and then write a paragraph for each, discussing ways that...

Q:

Make a method that counts and outputs the information for all of the Bagels with some type of spread on them. INPUT PARAMETER(S) : No input OUTPUT TO CONSOLE : Bagel information, when it has a...

Q:

A 1-kg steel ball and a 2-m cord of negligible mass make up a simple pendulum that can pivot without friction about the point O, as in Figure. This pendulum is released from rest in a horizontal...

Q:

ltiple Select Question Select all that apply Which of the following are reasons why corporations sell bonds? Multiple select question. They need money to finance ongoing activities. They don't like...

Q:

........................................................................................... \f

Q:

How are custom calculations developed that will refer back to columns in the Pivot Table on the same Excel worksheet?

Q:

What do the Length of Service and Length of Service Earnings Quotients indicate with reference to Female versus Male Wage and Job Progression in respect to Length of Service?

Q:

How do Excel Pivot Tables handle data from non OLAP databases?