Back to the Conceptual Data Model.
PURPOSE OF THESE FACTS :-
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
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.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.
13th. March 2002