Sql database structure example (part 2 another example

Feb 3rd, 2012
Studypool Tutor
Price: $60 USD

Tutor description

Sql database structure example (part 2 another example

Word Count: 2221
Showing Page: 1/11
The role of database administrator is to ensure the smooth functioning of the application with respect to the database. The database administrator performs the following tasks like Backup and Recovery, monitoring database activities and analyse the performance.1. The transactions that helps to identify or that can be used for analysis and forecasting needs to be stored in database in the given case study the transactions related to the customer sales and inventory needs to be stored. The data needs to be stored with respect to the date, which can be later retrieved for weekly, monthly or yearly forecasting.Table Name: Store Information:Fields: storeIDstoreNamestoreLocationaddresscontactDetailsTable Name: CustomersFields:customerIDcustomerNamecustomerAddresscustomerContactTable Name: ProductsFields: productIDproductNameproductCategoryproductPrice Table Name: InvoiceFields:storeIDproductIDcustomerIDquantitypurchaseDatetotalAmountThe Table Name: 'Invoice' contains the details of the customers and the items purchased with respect to the store location and the particular item purchased. This data helps to analyse and forecast the sales of a particular product with respect to the store.2. Business rules determine the usage of information, this in turn provides assistance for designing the database. The business rules also defines the access level to the information. Business rules will prevent just the repository of data. Business rules also known as

Review from student

Studypool Student
" Thanks for the help. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1830 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors