My projece make me confused which I didn't find clear things that make me understand
the required database and the relationships in it
So, would a super one help me to solve it ?!! ;D
this is required:
1) Model the data stored in the database (Identify the entities, roles, relationships, constraints, etc.)
2) Write the Oracle commands to create the database, find appropriate data, and populate the database
3) Write five different queries on your database, using the SELECT/FROM/WHERE construct provided in SQL.
Your five queries should illustrate several different aspects of database querying, such as:
a. Queries over more than one relation (by listing more than one relation in the FROM clause)
b. Queries involving aggregate functions, such as SUM, COUNT, and AVG
c. Queries involving complicated selects and joins
d. Queries involving GROUP BY, HAVING or other similar functions.
e. Queries that require the use of the DISTINCT keyword.
And this the condition that we need to determine it to solve the required Q's above :
5) It is desired to develop an Internet membership club to buy products at special prices online. To join, new members must be referred by another existing member of the club. The system will keep the following information for each member: The member ID, referring member, birth date, member name, address, phone, mobile, credit card type, number and expiration date. The items are always shipped to the member's address noted in the membership application. The shipping fees will differ for each order.For each item to be requested, the member will select an item from a long list of possible items. For each item in the database, we store an item ID, an item name, description, and list price. The list price will be different from the actual sale price. The available quantity and the back-ordered quantity (the back-ordered quantity is the quantity on-order by the club from its suppliers) is also noted