Customer Service Chat
Get quote & make Payment
Online Bakery Data Base Project, Database Management System
How much would you charge to create a database encompassing an Online Bakery with all the elements below?
I. Describe the application that you would like to design. This should include the purpose of the
application and an informal description of the application functionality. List and describe in detail the data
elements that must be captured in this application and stored in the database. The application may meet all
of the data needs of a business or may be specific to a single need within that business.
Note that you should not describe the TABLES that will contain this data… table design comes later. For
now, just make sure that you know what data points you want to capture. The names for these data should
not be database-style names, just plain English. While we will only be implementing the database for this
application, having this description will help guide the database development. Below is an example of a
II. Add "use cases" for your database. In this case, all you need is several (5-7 preferred) questions that
you would use your database application to answer. These should be Select queries and not database
updates or other database manipulation statements.
III. Draw one or more Entity-Relationship diagrams for your database. Optimally you will have 7-10
entities. (Otherwise consider modifying your project description.) Include a write-up discussing the
options that you have for this design and why you chose the option that you did. The E-R diagrams must
conform to the conventions that we have chosen to use in this class. The diagrams must be added to your
document; with E/R Assistant and most other drawing programs, you can cut and paste your diagrams
IV. Create the relational schema for your database based on your E-R diagram. Then revise this schema
to be normalized or, if you choose not to, explain why denormalized tables are preferable. Implement this
in your Oracle or MS SQL Server database and populate the database with test data. Your project should
a. the ERD
b. the relational schema (not CREATE TABLE statements)
c. a description of the normalization of these tables
d. the data definition statements that you used to create the tables; please do NOT turn in screen
captures, just the text of the statements
e. a sample of the statements for inserting data into the tables (two or three for each table will do);
please do NOT turn in screen captures, just the text of the statements
V. Write the SQL queries that support at least three of your use cases. Perform a screen capture showing
the results when you run these queries against your database. Please edit the screen capture to delete all
unnecessary text so that this will be legible to your readers. Finally, add a conclusion that briefly sums up
the project and any ideas you have for implementing it.
Assemble all of your project steps into a final project document. Your final project will be judged on:
o Presentation: Your project should be easy to read and attractively presented. It should be
understandable by someone who has not seen your project before.
Page 2 of 10
o Consistency: Even though this project was written in steps, the whole must be consistent: for
example, the ERD must be consistent with the data description.
o Completeness: All steps must be included in the final report including a conclusion.
o Correctness: The ERD, table schema, DDL, DML and SELECT statements must all be correctly
derived from the project introduction, data description and use cases.
Posted Date: 1/30/2013 1:40:10 AM | Location : United States
Ask an Expert
Online Bakery Data Base Project, Assignment Help, Ask Question on Online Bakery Data Base Project, Get Answer, Expert's Help, Online Bakery Data Base Project Discussions
Write discussion on Online Bakery Data Base Project
Your posts are moderated
Write your message here..
Eliminate repeating groups, Eliminate Repeating Groups The problem is, ...
Eliminate Repeating Groups The problem is, "Find out the list of employees, who knows DB2". For this problem we require to perform an awkward scan of the list looking for re
What is difference between truncate and delete, What is difference between ...
What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea
What is conceptual model, What is conceptual model ? A conceptual model...
What is conceptual model ? A conceptual model is a independent of both hardware and software.
Differentiate between b-tree and b+ tree, Differentiate between B-tree and ...
Differentiate between B-tree and B + tree Ans: A B-tree (or Balanced Tree) is a search tree along with additional constraints that makes sure that the tree is all the time
Explain domain-oriented relational calculus?, How does Tuple-oriented relat...
How does Tuple-oriented relational calculus vary from domain-oriented relational calculus? The tuple-oriented calculus uses a tuple variables i.e., variable whose only allowed
Domain constraints, Domain Constraints Domain constraints are primarily...
Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio
Develop a fragment of a hypothetical system, The objectives of this assignm...
The objectives of this assignment are: - to develop skills in the design of database driven applications - to develop skills in applying SQL to implement the relational and
Problems of concurrent transactions-lost updates, Lost Updates : Suppose th...
Lost Updates : Suppose the two transactions T3 and T4 run simultaneously and they happen to be interleaved in the following way (suppose the initial value of X as 10000):
State the objectives of object design, Determine the OBJECTIVES of object ...
Determine the OBJECTIVES of object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl
OLD HOME POLICIES, Write an sql statement to find what is the percentage of...
Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.