Create the necessary tables and table relationships for the following: Use the following information to create a
Fantastic news! We've Found the answer you've been seeking!
Question:
Create the necessary tables and table relationships for the following:
Transcribed Image Text:
Use the following information to create a database that supports all of the business needs for the Parking Permit Office. Create the necessary tables and table relationships. Populate the tables with the existing data. Enter data to give yourself a permit. Parking permits are issued to students, faculty, and staff. Only one parking permit per person is permitted. All types of individuals are treated in the same manner. Parking permit requests include: O Parking permit number > O O Citations are issued for parking violations. Citations are issued to both permit and non-permit holders. Each citation has only one violation. Citations include: O O O O Vehicle license plate number Person's name BE EM HA OA RA RD SD WL Citation Number Date of citation There are 8 types of violations: Violation Code Description Improper Parking Building Entrance Expired Meter Improper Parking Handicapped Area Improper Parking Other Area Improper Parking Reserved Area Time of citation Type of violation O Improper Parking Roadway Improper Parking Service Drive Improper Parking Walk/Lawn O O Fine $20 $15 $75 $20 $50 $15 $17 $22 For vehicles without permits License plate number For vehicles with permits Payments of fines are tracked. Payments can be made in installments. Payment records include: Payment Amount Date of Payment Permit number and license plate number Citation Number Existing Data O Assigned Permits can be found in "Permits Assigned to Owners.txt" O Existing Payments are in "Payments.xls" O License Plate numbers can be found in "license plate.txt" O O "citations.xls" All existing forms of data will continue to be collected. Name of people that are repeated across data files are the same individuals. Use the following information to create a database that supports all of the business needs for the Parking Permit Office. Create the necessary tables and table relationships. Populate the tables with the existing data. Enter data to give yourself a permit. Parking permits are issued to students, faculty, and staff. Only one parking permit per person is permitted. All types of individuals are treated in the same manner. Parking permit requests include: O Parking permit number > O O Citations are issued for parking violations. Citations are issued to both permit and non-permit holders. Each citation has only one violation. Citations include: O O O O Vehicle license plate number Person's name BE EM HA OA RA RD SD WL Citation Number Date of citation There are 8 types of violations: Violation Code Description Improper Parking Building Entrance Expired Meter Improper Parking Handicapped Area Improper Parking Other Area Improper Parking Reserved Area Time of citation Type of violation O Improper Parking Roadway Improper Parking Service Drive Improper Parking Walk/Lawn O O Fine $20 $15 $75 $20 $50 $15 $17 $22 For vehicles without permits License plate number For vehicles with permits Payments of fines are tracked. Payments can be made in installments. Payment records include: Payment Amount Date of Payment Permit number and license plate number Citation Number Existing Data O Assigned Permits can be found in "Permits Assigned to Owners.txt" O Existing Payments are in "Payments.xls" O License Plate numbers can be found in "license plate.txt" O O "citations.xls" All existing forms of data will continue to be collected. Name of people that are repeated across data files are the same individuals.
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided in the image we would need to create a database with several interrelated tables Below I will describe the tables al... View the full answer
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date:
Students also viewed these databases questions
-
Based upon the (Instructor-provided) five-year pro forma operating cash flow analysis, extend that exhibit to show after-debt service cash flows partitioned into those flowing to the limited partners...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.7 and 0.3, with the most recent observation weighted higher. PERIOD DEMAND 10............ 248...
-
A cubical tank is 3 3 3 m and is layered with 1 meter of fluid of specific gravity 1.0, 1 meter of fluid with SG = 0.9, and 1 meter of fluid with SG = 0.8. Neglect atmospheric pressure. Find (a)...
-
On January 1 of this year, Nowell Company issued bonds with a face value of $ 100,000 and a coupon rate of 8 percent. The bonds mature in five years and pay interest semiannually every June 30 and...
-
A water siphon having a constant inside diameter of 3 in. is arranged as shown in Fig. P5.100. If the friction loss between \(A\) and \(B\) is \(0.8 V^{2} / 2\), where \(V\) is the velocity of flow...
-
The Moto Hotel opened for business on May 1.2017. Here is its trial balance before adjustment on May 31. Other data: 1. Insurance expires at the rate of $450 per month. 2. A count of supplies shows...
-
A projectile is launched towards a hill that is d= 306m away. The launch angle is=56.9 above the horizontal with an initial speed of v0 =84.6m/s.The hill can be approximated as a plane sloped at...
-
Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. April and May sales...
-
Anjali Pic has three construction contracts underway - contract red, contract blue and contract green. Contract red and contract blue started on 1 January 2019 and contract green started on 1...
-
Jamal is 8 miles away from his house. He rides his bike home toward home at a speed of 12 mph.. How far away from home is he after a half hour? 1 mile 2 miles O 3 miles 4 miles
-
Looking for figures and an explanation why the NBA's 50/50 revenue split embedded in their CBA helped increase their profits as a league in the long run and why other leagues like the NFL should...
-
A charge of -2.55 nC is placed at the origin of an xy-coordinate system, and a charge of 2.00 nC is placed on the y axis at y = 3.80 cm USD/JPY +0.61% Part A If a third charge, of 5.00 nC, is now...
-
A hummingbird beats its wings 200 times every second. What is the period? What is the frequency?
-
Explain the types of situations where each channel or technique of Communication would be most effective. Provide examples and facts for your audience. Avoid simply offering an opinion; rely on...
-
Let V be the set of vectors in R with the following definition of addition and scalar multiplication: 0 Addition: [I2+Y/2] 3/2 = Scalar Multiplication: Determine which of the Vector Space Axioms are...
-
A bar of a steel alloy that exhibits the stress-strain behavior shown in Figure 6.22 is subjected to a tensile load; the specimen is 375 mm (14.8 in.) long and has a square cross section 5.5 mm (0.22...
-
Stevenson Apparel is a manufacturer of fashion clothing that has just opened its first large retail store for selling in-season clothes at regular prices. The companys competitive strategy depends on...
-
DeGraaf Office Supplies is a national retailer of office supplies, equipment, and furnishings. The company opened its first store in 1932, in Columbus, Ohio. Currently, DeGraaf has 300 stores...
-
What are the names of some current cloud computing vendors other than those discussed in the text? Do you think that all firms should use cloud vendors, or are there some reasons why they should be...
-
Consider two hypersonic wind tunnels with the same reservoir temperature of \(3000 \mathrm{~K}\) in air. (a) One tunnel has a test-section Mach number of 10. Calculate the flow velocity in the test...
-
The reservoir temperature calculated in problem 5.20 is beyond the capabilities of heaters in the reservoir of continuous-flow wind tunnels using air. This is why you do not see a Mach 20...
-
As problems 5.18 and 5.19 reflect, the air temperature in the test section of conventional hypersonic wind tunnels is low. In reality, air liquefies at a temperature of about \(50 \mathrm{~K}\)...
Study smarter with the SolutionInn App