Given scenario

Prepare the plan for the following databases with precise data types and constraints the table name and its fields name are to be obtained from database explanations which are given blow:
A database is being designed for storing sales information system. A product can be described with a unique product number, product name, selling price, company name. The product can sale to a particular customer and each customer has its own unique customer number, customer name, customer addresses and total balance to be required to be paid. each customer orders to buy product from the salesman .in the order ,it has unique sales order number , sales order date , customer number , salesman number , billed whole payment by the party or not and its delivery date . the salesman have the name ,addresses , salary of the sales man , delivery date , total quantity ordered , product rate.

Task1. Prepare the database by using normalization process.

Task2. Create the tables in oracle and apply the constraint ( like primary key , foreign key , unique , not null) where it is required to keep the database integrity.

Write the sql queries for the following to apply data mining approach :
Retrieve the list of amen and the address of all the customers
List the various products available
Find the names of all customers having “a” as the first letter In their names
List all the customers who are located In Dubai
Find the products whose selling price is greater than 2000 and less than or equal to 5000

انا مش فاهمه ايش المطلوب بالزبط اوي ايش اللي بتسالي عنه بالزبط ياريت توضحي عشان اعرف اساعدك

مشكوره اختي علي الرد ابي اعرف كيف احل السؤال الثاني بعد ملسويت الجدوال primary key , foreign key

هذا الي فوق عباره عن جدوال عرفتي كيف

ياريت التوضيح أكتر

اه انتي بدكك الجزء الخااص بال queries المطلوبه

السلام عليكم ورحمة الله

يمكنك عرض تصميم الجداول التى اعددتها ... حتى يمكن المساعدة

اليك هذا النصور عن الجداول والعلاقات بينها

يمكنك انشاء الجداول ثم ادخال بيانات تجريبية ثم تنفيذ اوامر الsql المطلوبة

sales_script.txt

اشكركن جميعنا علي المساعده Amgad هذا الي انا ابيها بقول لج شو سويت باول بس ما عرفت اسوي third normal form (3nf

تم تعديل 18 مايو 201114 سنة بواسطة موزه

Task 1:

First normal form (1NF)
{product number , product name, selling price , company name , customer number , customer name , customer addresses , total balance, sales order number , sales order date, customer number ,sales man number , delivery date , bill payment, salesman name, salesman addresses, salesman salary , delivery date, total quantity order , product rate}
Second normal form (2NF)
Product {product number, product name, selling price, company name}

Customer {customer number, customer name, customer addresses, total balance}
Order {sales order number, sales order date, customer number, sales man number, delivery date, bill payment}

Salesman {sales man number, salesman name, salesman addresses, salesman salary, delivery date, total quantity order, product rate}

third normal form (3NF)

هذا الجدوال فهمت علي بنات

ليش ماتردون بنات

شكراً لك أخي العزيز أمجد على مجهودك الرائع لتصميم هيكلية الجداول والله تستحق الشكر تأخذ من وقتك لحل مشاكل الكل الله يحفظك يأمجد
أخوك ...