Facebook Pixel Code
x
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Design and create a database to solve a real world problem Essay Example

Show related essays

Design and create a database to solve a real world problem

This is a preview of the 4-page document
Read full text

The design of the database will entail generation of tables using SQL, entity relationship diagrams using SQL Workbench and the designs of forms and reports using Ms.The database architecture must also be defined which either can be centralized, parallel or distributed. In centralized architectures, one server machine executes operations on the database and includes standalone and simple networked client server systems. In parallel architectures, a database may be hosted on multiple processors to improve querying and response times and in distributed databases, they span multiple geographically separated machines to provide backup, improve performance, data redundancy for local users.In the database creation there are many alternatives to achieving that. One can chose to use the SQL command prompt, Microsoft access, MySQL workbench or php models such as Xampp. In this instance, SQL is used. The first step was creating a database called pizza using the SQL commands and then creating tables and inserting the values to them and defining their data types. For the suitable for vegetarian column, 1 stands for a yes and 0 stands for no. Attached are the DDL (Data Definition Language) and DML (Data Manipulation Language) scripts used to enter the values to the command prompt. Then proceeding to MySQL workbench to generate entity relationship diagrams. Also attached are the print screen images of the execution of the SQL command prompt when entering values. This is done by use of the reverse engineer command then selecting the database name saved in SQL and ensuring that all the objects have been selected. In making the entity relationships, click on model then proceed to create diagram from dialog objects. It shows an EER diagram where all the tables entered are shown.Next is to define the relationships between the tables. Relationships can be one to one, one to many or many to many. ‘Many to many’ relationship is rarely used in this context. Generate English statements to enable you determine relationships between the tables for example a customer can have or place many orders but no two similar order numbers can exist. For the first instance a one to many relationship is used and for the second, a one to one relationship is used. One has to define the schema which is the logical structure of the database and

This is a preview of the 4-page document
Open full text
Close ✕
Tracy Smith Editor&Proofreader
Expert in: Logic & Programming, Formal science & Physical science, Geography
Hire an Editor
Matt Hamilton Writer
Expert in: Logic & Programming, Environmental Studies, Physics
Hire a Writer
preview essay on Design and create a database to solve a real world problem
WE CAN HELP TO FIND AN ESSAYDidn't find an essay?

Please type your essay title, choose your document type, enter your email and we send you essay samples

Contact Us