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
" Excellent work as usual "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1823 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