Assignment description
The following sample table shows the data of parking tickets at Millenium College
|
StID
|
LName
|
FName
|
PhoneNo
|
StLicNo
|
Ticket#
|
Date
|
Code
|
Fine
|
|
38249
|
Brown
|
Thomas
|
111-7804
|
BRY123
|
15634
|
10/17/14
|
2
|
$25
|
|
38249
|
Brown
|
Thomas
|
111-7804
|
BRY123
|
16017
|
11/13/14
|
1
|
$15
|
|
82453
|
Green
|
Sally
|
391-1689
|
TRE141
|
14987
|
10/05/14
|
3
|
$100
|
|
82453
|
Green
|
Sally
|
391-1689
|
TRE141
|
16293
|
11/18/14
|
1
|
$15
|
|
82453
|
Green
|
Sally
|
391-1689
|
TRE141
|
17892
|
12/13/14
|
2
|
$25
|
You are asked to perform the following activities
1. Implement the normalized tables using MS-Access.
2. From the tables implemented in answer 1, using MS-Access to develop a query to display student ID and Lname who has ticket code number 2.
3. From the tables implemented in answer 1, using MS-Access to develop a query to display student Fname who has the highest fine of ticket.
4. From the tables implemented in answer 1, using MS-Access to develop a query to show numbers of tickets for each student.