Online Bakery Data Base Project, Database Management System

Assignment Help:
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
project description.
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
into Word.
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
contain:
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.

Related Discussions:- Online Bakery Data Base Project

Create student db and retrieve all student name in cs, Create a Student dat...

Create a Student database and Retrieve the names of all students majoring in ‘CS' Consider the following relational database: STUDENT (name, student#, class, major) COURSE (co

Give expression in both tuple calculus and domain calculus, Consider the fo...

Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for

Write short note on data models, Write short note on Data models? Data...

Write short note on Data models? Data models: A data model is an abstract model which elaborates how data is represented and accessed. The term data model has two commonly ac

What are the different types of interfaces provided by dbms, Question 1 Su...

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

Give short note on the following terms- dirty pages and etl, Give short not...

Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

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

Relational algebra, Relational Algebra is a set of basic operations used to...

Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re

Control as a state machine engine, Control as a State Machine Engine F...

Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang

What is trigger, What is trigger Triggers are statements that are imple...

What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.

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