Advanced database systems, Database Management System

Consider an information system designed for an online company which provides IT products and services

These include desktops, laptops, networking products, IT books, parts, and technical support etc. Purchases made through the online store can be collected from various outlets. Individual outlets are responsible for maintaining their respective stocks. The products and services are provided by contracted vendors. The information system can be viewed as a virtual shop which is capable to access all products and services in store across all outlets. Buyers are not aware of the existence of different outlets. In the virtual shop, a buyer can assemble a shopping cart and check out by paying in one transaction using Paypal. The buyer will designate a specific outlet for collection or request shipment.

     Briefly describe the system you use as the basis for your analysis.

Quantitative analysis

a. Make an estimation of the size of the product catalogue in your chosen product types. It should include both the number of records and the size of an individual record. State the basis of your estimate.

b. Make an estimation of the number of queries per day, and of the number of purchases. Estimate the size of two years of history of sales including both the number of records and the size of an individual record. State the basis for your estimates.

Posted Date: 3/9/2013 12:08:02 AM | Location : United States







Related Discussions:- Advanced database systems, Assignment Help, Ask Question on Advanced database systems, Get Answer, Expert's Help, Advanced database systems Discussions

Write discussion on Advanced database systems
Your posts are moderated
Related Questions

er diagtram for icici


What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re

Explain the Functional Mode with help of an example. Functional Model  The functional model shows a computation and functional derivation of data values in it without ind

Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

Define Query Processing Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to

Explain Network Model in DBMS? Network Model - It was formalised within the late year of 1960s through the Database Task Group of the Conference on Data System Language (DBTG

While using extract datasets it is required to have a special workarea for interface False.  It is not required to have a special workarea for interface

Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1