Create an entity relationship diagram using uml notation

Assignment Help Database Management System
Reference no: EM13963387

Create an Entity Relationship diagram using UML notation. To receive full credit for this assignment, your diagram must be well organized and include:

Each main entity type, labeled with an appropriate name and a designated primary key
Attributes of each entity type
All relationships between entities, each labeled with an appropriate name
Multiplicity constraints clearly identified for each relationship
All assumptions made when interpreting the requirements

You may use any software with drawing capabilities (e.g., Microsoft Word, LucidChart, or Visio) to complete this assignment.

Assignment:

A state-wide toll road system (MyStateTolls) allows users to buy an RF tag for use in paying tolls on their system. Each tag includes a unique tagID. In order to use the newly purchased tag a user must create a user account and add and activate the tag by ID. A user is either personal or commercial. The user registration system requires first and last name, street address, city, state, zip, and a bank account which will be charged for the tolls. The bank account is identified by nameOfBank, routingNumber, accountNumber, nameOnAccount, and permission to create reoccurring charges. Additionally a tag can be registered to only one vehicle. The vehicle must be identified by VIN, make, model, year, registrationID, stateOfRegistration, and class. The registration process allows for four classes of vehicle (passenger, commercial2axle, commercial4axle, commercialHeavy). A user can register more than one vehicle but each must have its own tag.

Once the registration has been completed an initial balance is set on the MyStateTolls account. Additionally the user selects the level of charge to be drawn from the bank whenever the account balance is below the current charge level. The levelOfCharge can be either $15, $30, or $50, so the initial balance will also be one of these values. While driving the tag is read directly by the MyStateTolls system and the account charged with the appropriate road travel fee. At the time of the charge a toll is identified by tagID, location, timeStamp including date, vehicleClass, and amount charged. When the balance on a toll account drops below the level to pay the current charge, the levelOfCharge is deducted from the registered bank account and added to the Toll account balance so that the balance always remains positive. If a vehicle is disposed of, the tag must be made inactive. The tag is not transferrable to another vehicle or user.

Reference no: EM13963387

Questions Cloud

Determine the income tax : Determine the income tax to withhold from the biweekly wages
The red division of the elsa company : Senior management is unhappy with the investment centre's return on investment. It asks the manager of the red division to submit plans to improve the ROI in the next year
Pressure inside the vessel remains 38.6 kpa.identify liquid : A vessel holding some liquid is placed in a vacuum chamber that is constantly pumped. Gas leaks from the vessel into the vacuum through a small hole, radius 4.15 micro m, but the pressure inside the vessel remains 38.6 kPa. After a day mass of the..
Explain what happens when the fan is turned on : A large electric fan operated on batteries is mounted at the mast of a sailboat to blow air into the sails when there is no wind. Explain what happens when the fan is turned on
Create an entity relationship diagram using uml notation : Create an Entity Relationship diagram using UML notation. To receive full credit for this assignment, your diagram must be well organized and include.
Financial statements and audit report for the county : Select one local government in your state or area and review the financial statements and audit report for the county or municipality. The financial statements of the government you selected should have at least three funds.
How long did the football remain in the air : After a touchdown a wide receiver threw a football into the stands to his girlfriend 139 meter through the air. while in flight, the football traveled at an average speed of 13.0 m/s. how long did the football remain in the air
How would our motivations change towards finding intelligent : In other words, if we advanced to a Type II or Type III civilization, how would our motivations change towards finding intelligent life elsewhere in the universe
Identity one specific control in physical security : Identity one specific control in each category and describe the control in details, including the asset that is being protected. Physical Security.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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