How many books are sold each month by the publisher

Assignment Help Computer Engineering

Reference no: EM132087373

The owners of Books'R'Us, Tom and Sarah Smith, would like a more efficient way to store inventory data and report on the various business essentials. They are also preparing to offer e-commerce on their website. A consulting firm has recommended capturing information in a database and linking access to the database for each store. Tom and Sarah purchased Microsoft SQL Server to do this

Imagine that you have interviewed the store owners, Tom and Sarah Smith, and these are the questions with which they are most concerned:

1. How many books are sold each month by the publisher? This is important because quantity discounts are available from the publisher.

2. Which authors are the biggest sellers of books in our stores? This is important because the publisher offers discounts for certain authors each month.

3. What books are associated with each publisher?

4. What are the most popular products besides books that are sold in each store? In addition to books, the stores sell magazines, café-specific products like coffee and pastries, and various gift products.

5. From what region(s) (by ZIP code) do customers visit our stores? This is important because it will assist with future marketing efforts.

6. What customer data must be stored for the e-commerce portion of the website?

Design considerations o In this section, include:

All the tables and their relationships. For each table, include:

Table name

All attributes (field names and their data type)

Keys (primary, foreign, etc.)

Note: This could be a diagram depicting the listed items as well ? If appropriate, include a process diagram

Reference no: EM132087373

Questions Cloud

Create a complex submit form that uses several features : The form must provide at least one optional field that only appears if it is appropriate for a previous selection.

What part of the brain has most likely been damaged : What part of the brain has most likely been damaged? Please cite your references.

Develop a career plan to prepare you for your transition : ITECH7402 PROFESSIONAL IT CULTURE - develop a career plan to prepare you for your transition into the IT profession upon your graduation

Measuring gene expression in the plant species : If provided microarrays capable of measuring gene expression in the plant species you have, what are the experiment and analysis steps involved

How many books are sold each month by the publisher : Which authors are the biggest sellers of books in our stores? This is important because the publisher offers discounts for certain authors each month.

Reasons with explanations : Suggest three reasons WITH explanations that could lead to such a result?

Define two classes : Use RDF-based syntax, define two classes, Man and Woman, and make sure they are disjoint. Do not use owl:disjointWith.

Can you alter the formatting so as this is printed multiples : Can you alter the formatting so as this is printed multiples it will be perfectly aligned as columns regardless of the size of the variables.

What will you tell your managers to convince them : How will you overcome their objections? Persuade your managers by overcoming their objections with compelling arguments.

User Account

All Pages