Develop a query to display student fname

Assignment Help Database Management System

Reference no: EM13775287

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.

Reference no: EM13775287

Questions Cloud

Greatest it security concern facing businesses today : Give your opinion on what you believe to be the greatest IT security concern facing businesses today and explain the main reason(s) why you believe such is the case

In this audit of the sales and collection cycle : What inherent risks are you concerned about? In this audit of the sales and collection cycle, which types of tests are you likely to emphasize?

Federal unemployment compensation tax-federal income tax : Federal Unemployment Compensation Tax. Federal Income Tax. State Unemployment Compensation Tax

Modern western worldview and the postmodern worldview : Based on your reading of the GCU Introduction and the textbooks, what is the main difference between the modern Western worldview and the postmodern worldview?

Develop a query to display student fname : 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.

Cost of paving parking area for employees and customers : Identify each of the following expenditures as chargeable to Land, Land Improvements, Buildings, Machinery and Equipment, or other account? Cost of paving parking area for employees and customers. Insurance during construction of building. Interest i..

Global giant like coca-cola begins operations : What kinds of advantages does such an expansion bring to the globalizing organization?

Describe setting and actions in italics : Describe setting and actions in italics. Use "hanging indent" to set the names apart from the dialog. Students must learn to work consistently on their assignments-too many students choose to make socializing.

Explain how this aspect may be relevant to your life : The author suggests four aspects of using the "sociological perspective" to understand human society. In 5-7 sentences, answer the following: Select one of the four aspects. Provide a unique example different from the textbook. Explain how this aspe..

User Account

All Pages