I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as they are my only options.

My project proposal and its overviewt needs to include the following:

Title page o Include project title, (and other information as you see fit)

Overview o General description of the project and supporting database

Justification o Why would you do this project?

What problem will this database solve?

What happens if you do not do this project?

Requirements o For each major feature:

Describe it

Explain why you need it

Design considerations

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 should be a diagram depicting the listed items as well As well as a process diagram

\

Scenario: BooksRUs is a local bookstore that started in 1978 in a small New England town. BooksRUs has been able to withstand the challenges of larger bookstore chains, as well as the internet giant Amazon.com, by offering new and used books and other products in a comfortable location that includes a caf with free WiFi. BooksRUs recently purchased another local bookstore called Great Books, USA, from an owner who is retiring. Both businesses use a simple bookkeeping system that includes Microsoft Excel. The owners of BooksRUs, 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. The consulting firm has hired you to complete the database for BooksRUs. In addition to creating the database, you will provide a report for your supervisor at the consulting firm; this report should describe the rationale for and proposed development of the database.

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?

End of project proposal

Systems analysis portion

After the project proposal i need some guidance on the systems analysis for my project, including a comprehensive entity-relation diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis. All sections of this milestone should be compiled into a single Word document.

Systems analysis should include:

A comprehensive entity-relationship diagram (ERD)

o This must include an appropriate set of attributes for each entity.

A relational model o Your relational model should be logical, should reflect strong understanding of the overall function of your database, and must comply with each of the requirements laid out in the ERD.

A functional dependencies diagram normalized into 3NF

o Based upon the ERD you create, devise dependency diagrams and normalize the data into 3NF.

o This step will require you to compile a collective list of all the functional dependencies in order to create the model.

o The data in this section must reflect the list of functional dependencies and must be accurately normalized into 3NF.

A functional relational schema normalized into 3NF

o Based upon the ERD and the dependency diagrams, create the relational schema and normalize the data into 3NF.

A list of proposed queries

o Based on the six questions that most concern the bookstore owners, develop a single query that will answer each question

end of systems analysis

After the systems analysis i need help with the database and overall project, these critical elements need to be addressed:

I. Database: You will use your entity-relationship diagram, relational model, functional dependencies diagram, and functional relational schema to inform the creation of your database. These will be submitted as part of your report.

A. Tables: Create at least four tables that will display the data that is important to the store owners. Identify the primary and foreign keys that are necessary to relate the tables. Include screenshots that show the tables you created.

B. Import Data: Use SQL statements to import the data into the tables you just created. You will come up with each of your data sets yourself. You should have at least five records for each table. Include screenshots that show the populated tables annotated with the SQL statements that you used.

C. Queries: After you have populated the tables, write queries to extract the data to answer the owners questions. Include screenshots that show each query and the corresponding query results.

II. Report: Although some parts of the report will be completed before or during the creation of the database, the report as a whole will be written after you have created the database.

A. Overview: Provide a concise overview of the problem you are solving and the database that you created to address the problem.

B. Justification: Analyze the business information storage problem you are solving. Why is the database the appropriate solution to the problem?

C. Benefits: What benefits in data management does the database you created have over a file system like the one the stores were previously using? What features and functions does a database have that a file system does not?

D. Features: Describe each of the major features of the database you created. Why are these features required?

E. Design: How did you design the database to manage the stores data? Discuss the tables you created and their relationships, including in your discussion the table name, attributes (field names and data types), and keys (primary and foreign). Consider including a diagram to support your response to this question.

F. Entity-Relationship Diagram (ERD): Develop an entity-relationship diagram that has an appropriate set of attributes for each entity.

G. Relational Model: Develop a relational model that is logical and complies with the requirements in your ERD.

H. Functional Dependencies Diagram: Based on your ERD, develop a functional dependencies diagram that accurately normalizes the data into third normal form (3NF).

I. Functional-Relational Schema: Based on your ERD and dependencies diagram, develop a relational schema that accurately normalizes the data into 3NF.

Thanks again

I need some help with my project proposal and its overview. it needs to include the following:

Title page o Include project title, (and other information as you see fit)

Overview o General description of the project and supporting database

Justification o Why would you do this project?

What problem will this database solve?

What happens if you do not do this project?

Requirements o For each major feature:

Describe it

Explain why you need it

Design considerations

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 should be a diagram depicting the listed items as well As well as a process diagram

\

Scenario: BooksRUs is a local bookstore that started in 1978 in a small New England town. BooksRUs has been able to withstand the challenges of larger bookstore chains, as well as the internet giant Amazon.com, by offering new and used books and other products in a comfortable location that includes a caf with free WiFi. BooksRUs recently purchased another local bookstore called Great Books, USA, from an owner who is retiring. Both businesses use a simple bookkeeping system that includes Microsoft Excel. The owners of BooksRUs, 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. The consulting firm has hired you to complete the database for BooksRUs. In addition to creating the database, you will provide a report for your supervisor at the consulting firm; this report should describe the rationale for and proposed development of the database.

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?

End of project proposal

Systems analysis portion

After the project proposal i need some guidance on the systems analysis for my project, including a comprehensive entity-relation diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis. All sections of this milestone should be compiled into a single Word document.

Systems analysis should include:

A comprehensive entity-relationship diagram (ERD)

o This must include an appropriate set of attributes for each entity.

A relational model o Your relational model should be logical, should reflect strong understanding of the overall function of your database, and must comply with each of the requirements laid out in the ERD.

A functional dependencies diagram normalized into 3NF

o Based upon the ERD you create, devise dependency diagrams and normalize the data into 3NF.

o This step will require you to compile a collective list of all the functional dependencies in order to create the model.

o The data in this section must reflect the list of functional dependencies and must be accurately normalized into 3NF.

A functional relational schema normalized into 3NF

o Based upon the ERD and the dependency diagrams, create the relational schema and normalize the data into 3NF.

A list of proposed queries

o Based on the six questions that most concern the bookstore owners, develop a single query that will answer each question

end of systems analysis

After the systems analysis i need help with the database and overall project, these critical elements need to be addressed:

I. Database: You will use your entity-relationship diagram, relational model, functional dependencies diagram, and functional relational schema to inform the creation of your database. These will be submitted as part of your report.

A. Tables: Create at least four tables that will display the data that is important to the store owners. Identify the primary and foreign keys that are necessary to relate the tables. Include screenshots that show the tables you created.

B. Import Data: Use SQL statements to import the data into the tables you just created. You will come up with each of your data sets yourself. You should have at least five records for each table. Include screenshots that show the populated tables annotated with the SQL statements that you used.

C. Queries: After you have populated the tables, write queries to extract the data to answer the owners questions. Include screenshots that show each query and the corresponding query results.

II. Report: Although some parts of the report will be completed before or during the creation of the database, the report as a whole will be written after you have created the database.

A. Overview: Provide a concise overview of the problem you are solving and the database that you created to address the problem.

B. Justification: Analyze the business information storage problem you are solving. Why is the database the appropriate solution to the problem?

C. Benefits: What benefits in data management does the database you created have over a file system like the one the stores were previously using? What features and functions does a database have that a file system does not?

D. Features: Describe each of the major features of the database you created. Why are these features required?

E. Design: How did you design the database to manage the stores data? Discuss the tables you created and their relationships, including in your discussion the table name, attributes (field names and data types), and keys (primary and foreign). Consider including a diagram to support your response to this question.

F. Entity-Relationship Diagram (ERD): Develop an entity-relationship diagram that has an appropriate set of attributes for each entity.

G. Relational Model: Develop a relational model that is logical and complies with the requirements in your ERD.

H. Functional Dependencies Diagram: Based on your ERD, develop a functional dependencies diagram that accurately normalizes the data into third normal form (3NF).

I. Functional-Relational Schema: Based on your ERD and dependencies diagram, develop a relational schema that accurately normalizes the data into 3NF.

Thanks again

s my only option. it needs to include the following:

Title page o Include project title, (and other information as you see fit)

Overview o General description of the project and supporting database

Justification o Why would you do this project?

What problem will this database solve?

What happens if you do not do this project?

Requirements o For each major feature:

Describe it

Explain why you need it

Design considerations

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 should be a diagram depicting the listed items as well As well as a process diagram

\

Scenario: BooksRUs is a local bookstore that started in 1978 in a small New England town. BooksRUs has been able to withstand the challenges of larger bookstore chains, as well as the internet giant Amazon.com, by offering new and used books and other products in a comfortable location that includes a caf with free WiFi. BooksRUs recently purchased another local bookstore called Great Books, USA, from an owner who is retiring. Both businesses use a simple bookkeeping system that includes Microsoft Excel. The owners of BooksRUs, 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. The consulting firm has hired you to complete the database for BooksRUs. In addition to creating the database, you will provide a report for your supervisor at the consulting firm; this report should describe the rationale for and proposed development of the database.

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?

End of project proposal

Systems analysis portion

After the project proposal i need some guidance on the systems analysis for my project, including a comprehensive entity-relation diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis. All sections of this milestone should be compiled into a single Word document.

Systems analysis should include:

A comprehensive entity-relationship diagram (ERD)

o This must include an appropriate set of attributes for each entity.

A relational model o Your relational model should be logical, should reflect strong understanding of the overall function of your database, and must comply with each of the requirements laid out in the ERD.

A functional dependencies diagram normalized into 3NF

o Based upon the ERD you create, devise dependency diagrams and normalize the data into 3NF.

o This step will require you to compile a collective list of all the functional dependencies in order to create the model.

o The data in this section must reflect the list of functional dependencies and must be accurately normalized into 3NF.

A functional relational schema normalized into 3NF

o Based upon the ERD and the dependency diagrams, create the relational schema and normalize the data into 3NF.

A list of proposed queries

o Based on the six questions that most concern the bookstore owners, develop a single query that will answer each question

end of systems analysis

After the systems analysis i need help with the database and overall project, these critical elements need to be addressed:

I. Database: You will use your entity-relationship diagram, relational model, functional dependencies diagram, and functional relational schema to inform the creation of your database. These will be submitted as part of your report.

A. Tables: Create at least four tables that will display the data that is important to the store owners. Identify the primary and foreign keys that are necessary to relate the tables. Include screenshots that show the tables you created.

B. Import Data: Use SQL statements to import the data into the tables you just created. You will come up with each of your data sets yourself. You should have at least five records for each table. Include screenshots that show the populated tables annotated with the SQL statements that you used.

C. Queries: After you have populated the tables, write queries to extract the data to answer the owners questions. Include screenshots that show each query and the corresponding query results.

II. Report: Although some parts of the report will be completed before or during the creation of the database, the report as a whole will be written after you have created the database.

A. Overview: Provide a concise overview of the problem you are solving and the database that you created to address the problem.

B. Justification: Analyze the business information storage problem you are solving. Why is the database the appropriate solution to the problem?

C. Benefits: What benefits in data management does the database you created have over a file system like the one the stores were previously using? What features and functions does a database have that a file system does not?

D. Features: Describe each of the major features of the database you created. Why are these features required?

E. Design: How did you design the database to manage the stores data? Discuss the tables you created and their relationships, including in your discussion the table name, attributes (field names and data types), and keys (primary and foreign). Consider including a diagram to support your response to this question.

F. Entity-Relationship Diagram (ERD): Develop an entity-relationship diagram that has an appropriate set of attributes for each entity.

G. Relational Model: Develop a relational model that is logical and complies with the requirements in your ERD.

H. Functional Dependencies Diagram: Based on your ERD, develop a functional dependencies diagram that accurately normalizes the data into third normal form (3NF).

I. Functional-Relational Schema: Based on your ERD and dependencies diagram, develop a relational schema that accurately normalizes the data into 3NF.

Thanks again