Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

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.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91631407
  • Price:- $25

Priced at Now at $25, Verified Solution

Have any Question?


Related Questions in DBMS

In this section the student is required to develop a

In this section, the student is required to develop a technical debate based on his/her understanding using available scientific literature. The answer to this question should not exceed three A4 Pages. In the traditiona ...

Question create the physical data model for the logical

Question: Create the physical data model for the logical data model that you submitted in IP3. This should include all of the data definition language SQL. Your submission should include all DDL needed to: Create the tab ...

A schools office of the registrar maintains data about the

A School's office of the registrar maintains data about the following entities: a) courses (including course number, title, credits, syllabus and prerequisites), b) course offerings (including course number, year, semest ...

This is a starting out with visual basic programming

This is a starting out with visual basic programming problem, meaning its a basic programming nothing advanced. Question: Add a linq statement to the combo box text-changed event to dispaly the city field of the selected ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

Assignment task -write and run sql statements to complete

Assignment Task - Write and run SQL statements to complete the following tasks Part A - DML 1. Show the details of the products where the product code starts with '22'. 2. Display the vendor details from areacode 615. 3. ...

The system development team at the xyz company is working

The system development team at the XYZ Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes: Invento ...

Assignmenta restaurant is designing a database to keep

Assignment A restaurant is designing a database to keep track of customer services. A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees. Each employee is define ...

Question 1 unified communications system eg email

Question: 1. Unified Communications System (e.g., email, conferencing, and messaging) - The local area network is slower than needed, especially for newer, cloud-based applications. The email system needs refurbishment a ...

Question create an erd for the following scenario once you

Question: Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As