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

  Do explain the process of normalization

Explain the context in which Normalization is used?

  Explain how data is physically stored and accessed

Explain how data is physically stored and accessed

  Identify the modality of the relationship

You are working on the database design that will support PPI's new order entry system. PPI has many thousands of customers around the world who place and pay for orders. One customer can place an order for many products at a time.

  Describe implement relationship between employees-projects

Describe how you would implement relationship between employees and projects in each of the given scenarios: Many employees can work on given project, but each employee can work on only single project.

  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 fifty states will not have ready access to the data.

  Design of the premiere products database

Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. A customer is not necessarily represented by a single sales rep but can be represented by several sales reps.

  Write a second select statement that uses

Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer.

  Create the database that contains each of the relations

Find all Governors General of Australia who were Barons at the time of their appointment. List them by Title and name and date that they were appointed to the position. Order the list by ascending date of appointment.

  Delete a contact by having the user enter the name

Delete a contact by having the user enter the name

  Complete a modified data dictionary for specialized register

Complete a modified data dictionary for a specialized registry/database for a disease or condition described in one of the scenarios that i will give to you

  Data collection procedures and data analysis techniques

Specify the approach (qualitative or quantitative), research design, sampling strategy, data collection procedures, and data analysis techniques to be used.

  What is the assignment operator

What is the problem with the following statement? 60 + 5 = grade, What is the problem with the following statement? lastName = "smith, What is the assignment operator

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