Create an entity relationship diagram

Assignment Help Database Management System
Reference no: EM13909646

For your final project you will create an Entity Relationship Diagram (ERD), create tables in your own database, and import data into these tables. For Part 1 of the Project, you will create the ERD. For Part 2 you will build the tables and load the data. For Part One of the Project, you will be working in the "Models" Area of MySQL Workbench:

Using the Data Dictionary Provided, you will create an ERD (or EED as MySQL calls it), using the Models utility.

MySQL will prompt you for the name of the schema (database) you want to create. You will use your CSS user name for the database. For example, my database is named "pranallo" because my user name is pranallo.

You Model must include the following elements:

1. All 5 tables listed in the Data Dictionary
2. For each Table make sure you include in your model:
a. The table name (as listed in Data Dictionary)
b. A column named exactly as listed in the Data Dictionary
c. The appropriate data type for each column (as listed in the Data Dictionary)
d. The appropriate column settings (keys, whether null, etc.)

Remember:

Primary Keys are automatically generated by defining the column as an "auto-increment" column. Don't forget to check this setting when you build the column.

Reference no: EM13909646

How an organization would allow programmatic access

A few years have passed, and the restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fi

Development of database systems

Database Systems and Administration (ECM38IS) - Evaluate the role of conceptual modeling in the development of database systems and apply the entity-relationship modeling app

Explain leaf of b tree which holds a sublist

Artificially small example of B+ tree is shown here (pdf). (Note only part of tree is shown in detail.) What nodes of example B+ tree are visited to find posting list for "d

Normalize the following table

Normalize the following table upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do

Gap is developing its database using object-oriented methods

Assume that GAP is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram on next

Excel for decision support modeling

Willy Wonka is considering starting a production line to produce fizzy lifting drinks. As Chief Oompa Loompa (COL) you have access to a wide variety of financial data to he

Opinion on use of a database application

It seems that every Internet search engine or electronic commerce Web site uses databases to provide dynamic content and structure to a Web site's content. Banks use databas

Sketch hash table to result from using hash function

Sketch hash table of length 11 which results from using hash function h(i) = (2i + 5) mod 11, to hash the keys 12, 44, 13, 88, 23, 94, 11, and 39,

Reviews

Write a Review

 
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