Review

1
Review
2
Focused concept

• Week 1
• Three separate types of functionality
• Data Management
• Application logic
• Presentation
• Single-tier, client-server, three-tier
  architecture
• How Do Databases Support the World Wide Web

3
Review for Exam

• Week 2
• Relational model table, key(PR,FK), row,
  column, domain,tuple/record, NULL value
• Data integrity, entity integrity, Referential
  Integrity, enterprise integrity
• Views, relationship (three types, how to model
  them)

4
Review for Exam

• Week 3
• Normalization
• Validating data (field level, table level)
• SQL statements

5
Review for exam

• Week 4
• Query boolean expressions, different types of
  queries (select,action, parameter, crosstab)
• Different types of joins (equ(inner)joins,
  left/right joins)

6
Review for exam

• Week 5 and week 6
• Form and report

7
Review for exam

• Week 10 HTML main concepts (host, URL, browser,
  web server.), heading, body, html format tags,
  list tags, table
• Week 11CSS (main concepts, selector, images)
• Week 12Movie, slide shows, map
• Week 13Forms, Javascript (alert box)

8
Practice (Monday)

• 1. Changing a light bulb
• 2. Make sure you have unplugged the lamp from
     the wall socket.
  4. Unscrew the old bulb.
  6. Get the new bulb out of the package.
  8. Check the wattage to make sure it's
     correct.

9
Practice (Monday)

• 2. .com/cgi-bin/display_results.pl"
• Extras name"extras" value"foot" /Footboard
• value"drawers" checked"checked" /Drawers (for
  underneath)
• value"casters" /Casters
• value"nosqueak" /Squeak proofing
• Please share any suggestions or comments with us
  
• name"comments" rows"3" cols"65"Comments?area

10
Practice (Monday)

• 3. srcthumb1.jpg" alt"Flowers on the Rambles"
  width"83" height"125" /
• alt"Fruit stand" width"103" height"67" /
• alt"Charcuterie" width"123" height"85" /
• alt"Canned goods, hams, wine, olives!"
  width"84" height"123" /

11
Practice (Monday)

• 1-i
• 2-a
• 3-d
• 4-f
• 5-b
• 6-g
• 7-h
• 8-c
• 9-h

12
Practice

• 1. Place letters in the blank
• Select query____c____
• ____d_________
• Form_____b_________
• Report____a_________
• a.Printable format of a query
• b. Used to create a user interface
• c. query to retrieve information from database
• d. indicates an HTML heading element

13
Practice

• 1. Place letters in the blank
• Select query____c____
• ____d_________
• Form_____b_________
• Report____a_________
• a.Printable format of a query
• b. Used to create a user interface
• c. query to retrieve information from database
• d. indicates an HTML heading element

14
Practice

• 2.1 Student-Advisor is a
• a. One to one relationshipb. One to many
  relationship
• c. Many to many relationship
• d. None of the above

15
Practice

• 2.2. The Relationships window in Microsoft Access
  can be accessed through the main menu by clicking
  __________.
• a.) Tools / Relationships...
• b.) View / Relationships...
• c.) File / Open Relationships...
• d.) Edit / Relationships...
• e.) Window / View Relationships...

16
Practice

• 3. Student
• PK id
• FK majorId
• Major
• PK majorId
• Relationship
• one to many (in this case)

17
Practice

• 3. SELECT Student.id, Student.name,
  Student.earnedCredit, Major.description
• FROM Major INNER JOIN Student ON Major.majorId
  Student.majorId
• WHERE Major.majorId'1'

18
Practice

• 4.

A baby elephant
A small tiger
19
Multiple choices

• 1. If a user has a Web browser on his or her
  computer, which requests a web page from a web
  server, which in turn requests data from a
  Database Management Systems on a separate server,
  then this system
• is a(n) ____________ architecture.
• a) single-tier
• b) two-tier
• c) three-tier

20
Multiple choices

• Which piece of code is a correct example of
  linking an external style sheet to a Web page?
• A.
• B.
• C.
• D.

21
Multiple choices

• To help make your code easier to understand and
  debug, you should make liberal use of
  ____________ tags in your source code.
• A..
• B.
• C. / /
• D.

22
Last practice

• action"mailtoxyz_at_yahoo.com"
• 
  Large
• 
  Medium
• 
  Small
• name"submit" /

23
Last practice