Purchase Solution

ERD using MySQL modeling tool

Not what you're looking for?

Ask Custom Question

1.Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD.
a). A customer must own at least one car to be in the system. The number of cars can not exceed five cars per customer.
b). A car is owned by one and only one customer.
c). A car may generate many maintenance records.
d). Each maintenance record is generated by one and only one car. e). Some cars have not (yet) generated a maintenance procedure.
f). Each maintenance procedure can use many parts but not more than three parts per procedure.
g). A part may be used in many maintenance records.

2. Use MS Visio to draw an entity-relationship diagram (ERD) for the JustLee Book database (reference the structure of the database in Figure in the Ppt presentation attached). Draw a fully-labeled ERD that includes entities, labeled relationships (indicate whether each relationship is mandatory or optional), primary keys, foreign keys, and cardinalities. Follow the format (Crow's Foot notation) and naming conventions .

Purchase this Solution

Solution Summary

ERD using MySQL modeling tool

Purchase this Solution

Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

C# variables and classes

This quiz contains questions about C# classes and variables.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.