Termpaper

Topics: Cloud computing, Database, Database management system Pages: 29 (4159 words) Published: August 19, 2014


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 Key
Emp_Id
Number
Foreign Key
Prod_Quantity
Number

Total_Price
Number

Trx_Date
Date

2. Design a database solution and the potential business rules that could be used to house the sales transactions of the department store. A business rule is defined as the constraint of the business aspect operating the business structure while controlling the business activity of the project. Here, the business rule action specifies on creating, updating, revising and eliminating the data in an information system Setting S.M.A.R.T Goals :

S-Specific Goals: specific goals are measured as concrete and possible goals with a broader prospect of being accomplished. It involves what is to be accomplished, Who should be serving, identifying and establishing requirements like time frame and other constraints. M-Measurable: Establishing the existing criteria to evaluate development towards the skill of each goal which is set in order to determine if it is a measurable outcome. A-Attainable: identifying goals that are considered as important and efficient in enlarging the competence, aptitude, skills, and economical capacity for the opportunity to reach those goals. R-Realistic: It is important for a goal to be realistic as it should correspond to the objectives and goal which can work practically in regard for substantial progress. T- Timely : Setting Timely goal process for the target goal to be discovered and measured. Transparency and prospective: Establishing a shared sense a affinity to connect the space between the prospects and transparent constraints of the business needs like expensive and reliability Consumer Data :

The process in where the unit area is not supposed to be disclosed or sell for an entity requesting the information which is not be used should be honored

Data Security:
Security control gives the detail specification of the accessible stage to the elements of data where the available limited data will be offered to the department....

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)
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • TERMPAPER
  • Termpaper
  • Termpaper
  • termpaper
  • Termpapers
  • termpaper
  • Termpaper
  • Termpaper

Become a StudyMode Member

Sign Up - It's Free