Advanced database systems, Database Management System

Assignment Help:

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.


Related Discussions:- Advanced database systems

Er-diagram, courier company er-diagram

courier company er-diagram

Structure of client server systems, Structure of Client Server Systems: In ...

Structure of Client Server Systems: In client/server architecture, clients show users who require services while servers give services. Both client and server are a combination of

What is cardinality ratio, What is Cardinality Ratio? Cardinality Rati...

What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa

Entity relationship, how to write tables and drow E-R diagrams for hosiptal...

how to write tables and drow E-R diagrams for hosiptal management system and how to normalize and cardinalities?

Describe logical data independence, Describe logical data independence ? ...

Describe logical data independence ? Logical Data Independence - It is the capacity to modify the conceptual schema without having to change external schemas or application p

Maping constraits, #question.what is mapping constraints and types?.

#question.what is mapping constraints and types?.

HRM, is Chipo carrying his baby

is Chipo carrying his baby

Prepare entity relationship diagram for models your design, This project re...

This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru.

Write short notes on data ware housing, Write short notes on data ware hous...

Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd