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
List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

Benefits of heap files 1.   This is a easy file Organisation method. 2.   Insertion is somehow capable. 3.   Good for bulk-loading data into a table. 4.   Best if file

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

Why does a DBMS query language is designed? A DBMS query language is designed to support end users who use English-like commands. support in the development of complex applicat

I need a professional to prepare a database to collect and store basic information. The information can be basic info such as contact details etc. One requirement i have is f

What are called multilevel indices? Indices with two or more levels are known as multilevel indices.

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

Saving Derived Attributes to Avoid Re-computation Data that is derived from other data should be stored in the computed form to avoid re-computation. For this, we could define

QUESTION (a) Consider a car database consisting of car model, car make, car origin, Engine capacity, color, cost.