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
1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows: σ AGE The resu

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug


Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu

Whst is logical schema ? Logical schema is the entire database.

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat