Info Systems for Managers Spring 2007

Midterm

 

Q1

Table 1

GPA
First Name Last Name Major GPA
Jose Azcona Finance 2.5
Reginald Raphael Art 2.6
Jamille Rose Accounting 2.9
Andre Armor Art 3.0
Edwin Sanchez Psychology 3.1
Korina Cruz` Biology 3.2
Brenda Pedersen Finance 3.3
Rebecca Matthews Finance 3.5

 

Table 2

Student info
Social Security Last Name First Name Age Telephone Number
123-46-6566 Matthews Rebecca` 21 (347) 697-0735
542-84-5624 Rose Jamille 22 (547) 545-2536
542-87-5752 Raphael Reginald 22 (347) 256-0353
574-18-8956 Sanchez Edwin 22 (547) 833-2664
845-24-5652 Pedersen Brenda 22 (917) 968-5008
874-42-1545 Armor Andre 23 (718) 359-7466
875-41-2433 Cruz Korina 21 (646) 641-0354
942-74-5642 Azcona Jose 21 (973) 542-4125

 

Q1a

Table 1

 

 

Table 2

 

Q1b

Q1c

SELECT Years.Year, [Student info].Age, [School Record].Major, [School Record].[First Name]
FROM (Years INNER JOIN [Student info] ON Years.[First Name] = [Student info].[First Name]) INNER JOIN [School Record] ON Years.[Last Name] = [School Record].[Last Name]
WHERE (((Years.Year)="senior") AND (([Student info].Age)>21));

quiery2 21nover
Year Age Major First Name
Senior 22 Accounting Jamille


 

Q1d

Table before Update

Student info
Social Security Last Name First Name Age Telephone Number
123-46-6566 Matthews Rebecca` 21 (347) 697-0735
542-84-5624 Rose Jamille 22 (547) 545-2536
542-87-5752 Raphael Reginald 22 (347) 256-0353
574-18-8956 Sanchez Edwin 22 (547) 833-2664
845-24-5652 Pedersen Brenda 22 (917) 968-5008
874-42-1545 Armor Andre 23 (718) 359-7466
875-41-2433 Cruz Korina 21 (646) 641-0354
942-74-5642 Azcona Jose 21 (973) 542-4125

Table after Update

School Record
Last Name First Name Gender Age Major
Armor Andre Male 23 Art
Azcona Jose Male 21 Finance
Cruz Korina Female 21 Biology
Matthews Rebecca Female 21 Accounting
Pedersen Brenda Female 23 Finance
Raphael Reginald Male 23 Art
Rose Jamille Female 23 Accounting
Sanchez Edwin Male 23 Psychology

UPDATE [School Record] INNER JOIN GPA ON [School Record].[Last Name]=GPA.[Last Name] SET [School Record].Age = 23WHERE ((([School Record].Age)=22));
 

 

Hosted by www.Geocities.ws

1