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

  Develop preliminary database tables for huffman trucking log

Use Microsoft Access to develop preliminary (no keys and no relationships) database tables for Huffman Trucking Driver Log.

  Which management used to evaluate oracle database offerings

What were the important business factors which management used to evaluate Oracle's database offerings

  Write the proper sequence of activities in the design

Write the proper sequence of activities in the design of a video rental database. The initial ERD is shown in above (or refer to textbook figure 9.9). The design must support all rental activities, customer payment tracking, and employee work sche..

  Explain how to develop a project charter

Using the above scenario, develop a project charter. Include the problem statement, justification for the project, and how the project will be measured for success.

  Development of the database

As an alternative for development of the database, you are considering outsourcing the functions above. Research the Internet and other media sources for vendors who develop registrar and school management database systems

  Multi-core mobile processor

Assume we have TINGEN, a multi-core mobile processor. As writing an application in assembly language for the certain device, we have two selections concerning code optimization.

  Object approach improve the systems development process

How is the object approach different from the data and process approaches to systems development? And how can the object approach improve the systems development process

  Logical development of appropriate data types

Demonstrate professional presentation skills by the development of a professional business presentation to the client outlining the development process for this Database Management System project.

  Design an expanded entity relationship model diagram

You are to design an Expanded Entity Relationship Model Diagram. An example of the Expanded Entity Relationship Model Diagram is seen in Figure 3.27 on page 89.

  Explain the need for key restructuring

Give at least three reasons why ETL functions are most challenging in a data warehouse environment.

  Hide the column containing the ssn numbers

Troubleshooting formulas and Data Entry in a Payroll Data Workbook for Irene's Scrapbooking World, Similar to other small businesses, Irene's Scrapbooking World outsources the processing of its payroll to its accounting firm. Hide the column containi..

  Design and build a small database application

Refine research and analysis skills through locating, selecting and compiling a higher-level research essay.

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