Database
Raghad Alshrefi
information_system_assignment.docxAdmin use case:
User use case:
Database design diagram:
|
Table |
Field Name |
Data Type |
Length |
Description |
|
Customer |
CustomerID |
Integer |
10 |
The ID number for each customer |
|
|
CustomerEmail |
Varchar |
25 |
The email for each customer |
|
|
LastName |
Varchar |
20 |
The last name for each customer |
|
|
Password |
Varchar |
6 |
The password for each customer |
|
|
PhoneNumber |
Integer |
6 |
The phone number for each customer |
|
|
City |
Varchar |
25 |
The city for each customer |
|
|
Country |
Varchar |
25 |
The country for each customer |
|
|
ShipAddress |
varchar |
30 |
That place that the product will be send to |
|
|
BillAddress |
Varchar |
30 |
The place that the bill will be send to |
|
|
UserName |
Varchar |
20 |
The user name for each customer |
|
Product |
ProductID |
Integer |
10 |
The ID number for each product |
|
|
ProductName |
Varchar |
20 |
The name for each product |
|
|
ProductPrice |
Integer |
10 |
The price for each product |
|
|
ProductImage |
Object |
35 |
The image for each product |
|
|
ProductDescription |
Varchar |
30 |
The description for each product |
|
|
ProductBrand |
Varchar |
20 |
The brand for each product |
|
|
ProductQuantity |
Integer |
30 |
The quantity for each product |
|
|
CategoryName |
Varchar |
20 |
The name for each category |
|
Employee |
EmployeeID |
Integer |
10 |
The ID number for each employee |
|
|
EmployeeName |
Varchar |
20 |
The name for each employee |
|
|
WorkingHours |
Integer |
20 |
The working hours for each employee |
|
Order |
OrderID |
Integer |
10 |
The ID number for each order |
|
|
CustomerID |
Integer |
10 |
Foreign key from the customer table |
|
|
ProductID |
Integer |
10 |
Foreign key from the product table |
|
|
EmployeeID |
Integer |
10 |
Foreign key from the employee table |
|
|
PaymentID |
Integer |
10 |
The number of the payment process that come from the bank |
|
|
Delivery |
Varchar |
30 |
The customer can choose if he want his products to be deliver for him or not |
|
|
Customer Evaluation |
Varchar |
50 |
Evaluation that the customer do it for the app in general |
|
|
Quantity |
Integer |
30 |
The quantity for each product |
|
|
Compliant&SuggestionID |
Integer |
10 |
The ID number for each compliant or suggestion |
|
|
CustomerID |
Integer |
10 |
Foreign key from the customer table |
|
Cart |
CustomerID |
Integer |
10 |
Foreign key from the customer table |
|
|
ProductID |
Integer |
10 |
Foreign key from the product table |
|
|
Quantity |
Integer |
30 |
The quantity for each product |
|
Promotion |
PromotionID |
Integer |
10 |
The ID number for each promotion |
|
|
PromotionDataFrom |
Date |
15 |
From which date the promotions will start |
|
|
PromotionDataTo |
Date |
15 |
The final date for the promotions |
|
|
ProductID |
Integer |
10 |
Foreign key from the product table |
|
|
NewPrice |
Integer |
10 |
The new price for the product after the promotion |
|
|
Description |
Varchar |
25 |
The description for each product after promotion |
|
|
Quantity |
Integer |
30 |
The quantity for each product after promotion |
|
|
Type |
Varchar |
20 |
The type of the promotion of the product if it is weekly offer or hot offer |
