Termpaper
1.Identify the potential sales and department store transactions that can be stored within the database.
The given Departmental Store Database will have retail sales which gives the information regarding the store sales transactions in which the sales sale process consists of a customer having the purchase to a store.
The assumptions made for this case study are:
1. Departmental Stores consists of five stores located in five different locations.
2. Departmental store consists of Store, Employee, Customer and product.
3. One Store consists of many employees and (many employees can work in a single store).
4. One Store consists of many customers and( many customers will be accessible to one store)
5. One Store consists of many products and (many products will be available in one store)
6. Products are expected from dealer
7. Store sales the products from the retail stores
The following Entities are derived from the above transactions which need to be stored in the databases and maintained in the department’s stores.
Table Description
AT_STORES :
Attribute Name
Attribute Type
Attribute Description
Store_Id
Number
Primary Key
Store_Name
String(100)
Store_Address
String(360)
Store_Phone
Number
AT_EMPLOYEE
Attribute Name
Attribute Type
Attribute Description
Emp_Id
Number
Primary Key
Emp_Name
String(100)
Emp_Address
String(360)
Emp_Phone
Number
AT_CUSTOMER
Attribute Name
Attribute Type
Attribute Description
Cust_Id
Number
Primary Key
Cust_Name
String(100)
Cust_Address
String(360)
Cust_Phone
Number
AT_PRODUCT
Attribute Name
Attribute Type
Attribute Description
Prod_Id
Number
Primary Key
Prod_Name
String(100)
Prod_Type
String(30)
Prod_Price
Number
AT_PRODUCT
Attribute Name
Attribute Type
Attribute Description
Trx_Number
Number
Primary Key
Cust_Id
Number
Foreign Key
Store_Id
Number
Foreign Key
Prod_Id
Number
Foreign
The given Departmental Store Database will have retail sales which gives the information regarding the store sales transactions in which the sales sale process consists of a customer having the purchase to a store.
The assumptions made for this case study are:
1. Departmental Stores consists of five stores located in five different locations.
2. Departmental store consists of Store, Employee, Customer and product.
3. One Store consists of many employees and (many employees can work in a single store).
4. One Store consists of many customers and( many customers will be accessible to one store)
5. One Store consists of many products and (many products will be available in one store)
6. Products are expected from dealer
7. Store sales the products from the retail stores
The following Entities are derived from the above transactions which need to be stored in the databases and maintained in the department’s stores.
Table Description
AT_STORES :
Attribute Name
Attribute Type
Attribute Description
Store_Id
Number
Primary Key
Store_Name
String(100)
Store_Address
String(360)
Store_Phone
Number
AT_EMPLOYEE
Attribute Name
Attribute Type
Attribute Description
Emp_Id
Number
Primary Key
Emp_Name
String(100)
Emp_Address
String(360)
Emp_Phone
Number
AT_CUSTOMER
Attribute Name
Attribute Type
Attribute Description
Cust_Id
Number
Primary Key
Cust_Name
String(100)
Cust_Address
String(360)
Cust_Phone
Number
AT_PRODUCT
Attribute Name
Attribute Type
Attribute Description
Prod_Id
Number
Primary Key
Prod_Name
String(100)
Prod_Type
String(30)
Prod_Price
Number
AT_PRODUCT
Attribute Name
Attribute Type
Attribute Description
Trx_Number
Number
Primary Key
Cust_Id
Number
Foreign Key
Store_Id
Number
Foreign Key
Prod_Id
Number
Foreign
References: ASD (1997–2014). Cloud Computing Security Considerations Retrieved on June 15th 2014 from http://www.asd.gov.au/publications/csocprotect/cloud_computing_security_considerations.htm Carlos coronel (2013). Database Systems design, implementation and management 10th edition Cloud Computing Price Comparison Engine Retrieved on June 14th 2014 from http://www.cloudorado.com/ Gigenet (2014) http://gigenet.com/cloud-servers/gigenet-cloud-pricing/ Oracle White Paper (October, 2013) June 15th 2014 from http://www.oracle.com/technetwork/oem/cloud-mgmt/dbaas-overview-wp-1915651.pdf Scale DB (2012) http://www.scaledb.com/DBaaS-Database-as-a-Service.php TechTarget (2009 - 2014)