Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Develop a database for the Department of Public Safety which records students, their automobiles, the decal # of the cars, and the parking lots with
Develop a database for the Department of Public Safety which records students, their automobiles, the decal # of
the cars, and the parking lots with their capacities. The goal is to see that students are parking their cars in the
right parking lot and that the decal details matches the physical car.
A student may have one or more cars but a car can only belong to one student.
Decide on tables, their fields, the datatypes of the fields, their primary and foreign keys if any.
Develop the queries
Develop a formsmain form & subform.
Note that eventually, the system needs to handle students, cars, and parking lots. The parking lot is
eventually going to have a lot more details than shown here such as location, lighting situation, etc
The database file should be of type accdb.
A partial data relating to students are as follows:
Mr Charles Smith, male, Winter Street, Providence, RI commuterYes; cell phone:
; email smith@bryant.edu,
Ms Mary Gitten, female, Townhouse A Bryant University, Smithfield, RI commuterNo;
cell phone: ; emailgitten@bryant.edu,
Mr John Prichard, male, Townhouse B Bryant University, Smithfield, RI commuterNo;
cell phone: ; emailprichard@bryant.edu
Ms Mary Wilson, female, Townhouse F Bryant University, Smithfield, RI commuterNo;
cell phone: ; emailwilson@bryant.edu
Mr Mike Pence, male, Hope Street, Smithfield, RI commuterYes; cell phone:
; emailpence@bryant.edu
Ms Hillary Dutton, female, Townhouse H Bryant University, Smithfield, RI commuterNo;
cell phone: ; emaildutton@bryant.edu
The details of automobiles owned by the students are as follows.
Mr Smith owns the following automobiles
Plate# Mazda, Miata, value $ Decal# and Plate # Acura,
MDX value $ Decal# Both assigned to parking lot A
Ms Gitten owns the following: Plate # Ford, Fusion, value $ Decal# Assigned to
Parking lot B
Mr Prichard owns the following automobiles
Plate# Toyota, Corola, value $ Decal# and Plate #
Acura, RDX value $ Decal# Both assigned to parking lot A
Ms Wilson owns the following: Plate # Ford, Fusion, value $ Decal# Assigned to
Parking lot C
Mr Pence owns the following automobiles
Plate# Honda, Civic, value $ Decal# and Plate #
Acura, TL value $ Decal# Both assigned to parking lot B
Ms Dutton owns the following: Plate # Ford, Escape, value $ Decal# Assigned to
Parking lot C
Parking lot A has capacity for cars, parking lot B has capacity for cars and parking lot C has
capacity for cars
Questions:
Add more record for a student owning a single car Make up your own data in the format
above. The car values to be $ and the cars to be assigned to Parking lot A
Develop tables that are needed to store details of students, cars and parking lots.
Design tables with appropriate datatypes and assign primary keys to the tables and foreign keys
to relate the tables
Insert data as above including your two records into the tables.
Develop queries as follows:
Q: List all students who are females and their details.
Q: List all students who are male and are commuters and their details
Q: List automobiles and their details for automobiles valued between $ and
$ and are assigned to lots A or C
Q: List all student ID and Plate Ids for cars that are assigned to parking lot having
capacity more than cars and have car values above $
Develop a mainform and subform where the mainform displays the details of the
student and subform displays the details of the automobiles
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started