Database Answers Header 1936 Cord
Hardware Sales
Home Ask a Question Data Models FAQs Search Site Map  
Underwater in Fiji Back to the Conceptual Data Model.

These FACTS define the functional requirements which the Database must meet.
They form the basis for agreement between the User and the Database Designer and are
written in a form of structured English which is clear and unambiguous.
The Draft FACTS have been defined and are detailed here ...

A. The Area being Modelled is :- Hardware Items Purchased

User Requirements :- 
I have the following relations:

Clients (client-id, client-name, client-address)
Item-status (item-code, item-name, item-quantity available)
Item-client (client-code, item-code, data of purchase, quantity purchased)
Item-staff member (item-code, staff-member-code, staff-member-name)	

Create the following queries using SQL :

i)  Find the clients who have purchased any of the items named "Central Processor"
    , "Memory", "Hard Disk" and have purchased a total quantity of all these items 
    above 1000.
ii) Find out the staff-member-code and names of those members who have been dealing 
    with the times which has been sold the maximum quantity.

B. The Things of Interest, ('THINGS'), include :-
B.1 Clients
B.2 Purchases
B.2 Sale Items 
B.3 Staff Members  

C. These THINGS_OF_INTEREST are Related as follows :-
C.1 Each Client purchases zero, one or many Sale Items.
C.2 Each Client can deal with zero, one or many Staff Members.
C.3 Each Staff Members can deal with zero, one or many Clients.
D. What else do we know about the THINGS_OF_INTEREST :-
D.1 To be determined.
E. Sample Data includes :-
E.1 To be determined

F. Typical Enquiries include :-
F.1 To be determined.

Barry Williams
Principal Consultant
Database Answers
13th. March 2002

[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

© IceBreaker WebDesigns 2002