Expert answer:7-1 Final Project Submission: Database and Report
Solved by verified expert:Your database and report should answer the following prompt: Create a database that meets the needs of the store owners. In addition to the database, you will also submit a report that includes several models and diagrams that you completed earlier in the course to inform your database creation; you will now resubmit these models and diagrams after incorporating your instructor’s feedback. Databases are increasingly important in the information age, as they provide a means to organize, track, manage, and use information easily and efficiently. Thousands of companies depend on databases to record and update data. Databases have a wide variety of uses, from tracking climate measurements worldwide to storing library research information to organizing user data for businesses and organizations.For this assessment, you will solve an information storage problem. The owner of two local bookstores wants to consolidate individual store inventories. You will organize the store inventory data into workable tables and apply normalization techniques to create a single common SQL-based database that can be shared between the stores. In addition, you will submit a report explaining the choices you made in the creation of your database. The report will also include an entity-relationship diagram and other models as well as a description of the database design features.Some components of this final project will have been developed earlier in the course and submitted for instructor feedback. You will submit them a second time as part of this final project, incorporating the feedback that you received from your instructor. This project is divided into two milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be due in Modules Two and Four. The final database and report will be submitted in Module Seven.
it330_final_project_guidelines_and_rubric.pdf
Unformatted Attachment Preview
IT 330 Final Project Guidelines and Rubric
Overview
Databases are increasingly important in the information age, as they provide a means to organize, track, manage, and use information easily and efficiently.
Thousands of companies depend on databases to record and update data. Databases have a wide variety of uses, from tracking climate measurements
worldwide to storing library research information to organizing user data for businesses and organizations.
For this assessment, you will solve an information storage problem. The owner of two local bookstores wants to consolidate individual store inventories. You will
organize the store inventory data into workable tables and apply normalization techniques to create a single common SQL-based database that can be shared
between the stores. In addition, you will submit a report explaining the choices you made in the creation of your database. The report will also include an entityrelationship diagram and other models as well as a description of the database design features.
Some components of this final project will have been developed earlier in the course and submitted for instructor feedback. You will submit them a second time
as part of this final project, incorporating the feedback that you received from your instructor. This project is divided into two milestones, which will be
submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be due in Modules Two and
Four. The final database and report will be submitted in Module Seven.
This assessment addresses the following course outcomes:
Differentiate between database systems and file systems by comparing features and functions to determine benefits in data management
Analyze business information storage problems for depicting suitable information model solutions using entity relation diagrams
Apply database normalization theory to relational data models for defining relationships and minimizing redundancy
Develop solutions to query and data update problems using a Structured Query Language interface to create, populate, maintain, and query databases
Scenario
Books’R’Us is a local bookstore that started in 1978 in a small New England town. Books’R’Us 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. Books’R’Us 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 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. The consulting firm has hired you to complete the database for Books’R’Us. 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.
2.
3.
4.
How many books are sold each month by the publisher? This is important because quantity discounts are available from 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.
What books are associated with each publisher?
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?
Prompt
Your database and report should answer the following prompt: Create a database that meets the needs of the store owners. In addition to the database, you
will submit a report that includes several models and diagrams that you completed earlier in the course to inform your database creation; you will resubmit
these models and diagrams after incorporating your instructor’s feedback.
Specifically, the following critical elements must 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 owner’s 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.
Milestones
Milestone One: Project Proposal
In Module Two, you will submit a project proposal and its overview as a Word document. This milestone is graded with the Milestone One Rubric.
Milestone Two: Systems Analysis
In Module Four, you will submit a systems analysis for your 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. This milestone is graded with the
Milestone Two Rubric.
Final Project Submission: Database and Report
In Module Seven, you will submit your database and report. Your database and report should answer the following prompt: Create a database that meets the
needs of the store owners. In addition to the database, you will also submit a report that includes several models and diagrams that you completed earlier in the
course to inform your database creation; you will now resubmit these models and diagrams after incorporating your instructor’s feedback. This submission is
graded with the Final Project Rubric.
Final Project Rubric
Guidelines for Submission: Your report should adhere to the following formatting requirements: 5–7 pages, double-spaced, using 12-point Times New Roman
font and one-inch margins.
Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information,
review these instructions.
Critical Elements
Tables
Exemplary (100%)
Meets “Proficient” criteria and
demonstrates nuanced
understanding of table
relationships
Import Data
Meets “Proficient” criteria and
demonstrates nuanced
understanding of SQL
Queries
Overview
Justification
Benefits
Proficient (85%)
Creates at least four tables that
will display the data that is
important to the store owners
and accurately identifies the
primary and foreign keys
necessary to relate the tables
Accurately uses SQL statements
to import data to tables,
displaying at least five records
per table
Writes queries that accurately
extract the data to answer
owners’ questions
Provides concise overview of
problem and database that was
created to address problem
Needs Improvement (55%)
Creates at least four tables and
identifies primary and foreign
keys, but with gaps in accuracy,
relevance, or detail
Uses SQL statements to import
data to tables, displaying at least
five records per table, but with
gaps in accuracy or detail
Meets “Proficient” criteria and
Writes queries that extract data,
demonstrates nuanced
but with gaps in accuracy,
understanding of SQL
relevance, or detail
Meets “Proficient” criteria, and
Provides overview of problem to
overview is exceptionally clear
be solved and database that will
and contextualized
be created to address problem,
but overview is wordy or vague
Meets “Proficient” criteria, and Thoroughly analyzes the business Analyzes the business
analysis is exceptionally clear and information storage problem and information storage problem and
contextualized
explains why the database is the explains why the database is the
appropriate solution to the
appropriate solution to the
problem
problem, but is cursory or
inaccurate
Meets “Proficient” criteria and
Comprehensively describes
Describes benefits, features, and
demonstrates nuanced
benefits, features, and functions functions of databases compared
understanding of differences
of databases compared to file
to file systems, but with gaps in
between databases and file
systems
accuracy or detail
systems
Not Evident (0%)
Does not create at least four
tables
Value
7.92
Does not use SQL statements to
import data to tables
7.92
Does not write queries that
extract the data to answer
owners’ questions
Does not provide overview of
problem to be solved and
database that will be created to
address problem
Does not analyze the business
information storage problem and
does not explain why the
database is the appropriate
solution to the problem
7.92
Does not describe benefits,
features, and functions of
databases compared to file
systems
7.92
7.92
7.92
Features
Design
Entity-Relationship
Diagram
Meets “Proficient” criteria and
demonstrates nuanced
understanding of database
features
Meets “Proficient” criteria and
discussion is supported with
diagram(s)
Meets “Proficient” criteria and
demonstrates nuanced
understanding of entities,
attributes, and relationships
Relational Model
Meets “Proficient” criteria and
demonstrates strong
understanding of overall function
of database
Functional
Meets “Proficient” criteria and
Dependencies
demonstrates nuanced
Diagram
understanding of relationship
between database normalization
theory and relational data
models
Functional-Relational Meets “Proficient” criteria and
Schema
demonstrates nuanced
understanding of relationship
between database normalization
theory and relational data
models
Articulation of
Submission is free of errors
Response
related to citations, grammar,
spelling, syntax, and organization
and is presented in a
professional and easy-to-read
format
Comprehensively describes
major features of database and
explains why they are required
Describes major features of
database and explains why they
are required, but with gaps in
accuracy or detail
Thoroughly describes database
Describes database design,
design, tables, and relationships, tables, and relationships, but
supporting discussion with table description is cursory,
names, attributes, and keys
inaccurate, or not supported
with table names, attributes, and
keys
Develops entity-relationship
Develops entity-relationship
diagram that has appropriate set diagram, but not all attributes
of attributes for each entity
are appropriate for entities
Does not describe major features
of database and does not explain
why they are required
7.92
Does not describe database
design, tables, and relationships
7.92
Does not develop entityrelationship diagram
7.91
Develops logical relational model Develops relational model, but
that complies with ERD
there are gaps in logic or
requirements
compliance with ERD
requirements
Develops a functional
Develops a functional
dependencies diagram that
dependencies diagram that
accurately normalizes data into normalizes data into 3NF, but it
3NF, based on ERD
is not based on ERD or has gaps
in accuracy
Does not develop relational
model
7.91
Does not develop a functional
dependencies diagram
7.91
Creates relational schema that
accurately normalizes data into
3NF, based on ERD and
dependencies diagram
Creates relational schema that
normalizes data into 3NF but is
not based on ERD or
dependencies diagram or has
gaps in accuracy
Does not create relational
schema
7.91
Submission has no major errors
related to citations, grammar,
spelling, syntax, or organization
Submission has major errors
related to citations, grammar,
spelling, syntax, or organization
that negatively impact
readability and articulation of
main ideas
Submission has critical errors
related to citations, grammar,
spelling, syntax, or organization
that prevent understanding of
ideas
Earned Total
5
100%
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades