Transcript insert godin

IST210
1
FINAL PRESENTATIONS
IST 210 Organization of Data
IST210
Awesome projects!
2
IST210
3
Group 9: Ticket Lion
Two persons team!
IST210
Group 2: Uselfie
4
IST210
Group 8: Used Car Finder
5
IST210
6
Group 11: BarHub!
No programming background!
IST210
Group 4: CarMatch
7
IST210
Group 7: RideShare
No programming background!
8
9
IST210
Group 5: Nittany Help
Most data!
IST210
Group 6: FoodFriend
10
IST210
Group 3: Yummy
11
IST210
Group 1: Another Round
12
IST210
Group 10: Plot my course
13
IST210
The third place goes to…
Nittany Help
Alex Weber Ishani Viradiya YooKyung Kim Nada Ziab
https://my.up.ist.psu.edu/nfz5007/main.php
14
IST210
Honorable mention
Ticket Lion
Hilary Godin, David Brilliant
https://my.up.ist.psu.edu/dsb5304/website2/main.php
15
IST210
16
The runner up is…
Yummy
John Esteves, Le Fang, Daniel McPhillips, Benjamin Rader
https://my.up.ist.psu.edu/dpm5276/yummy/index.html
IST210
17
Tied second place…
Used Car Finder
Christopher Silverwood, Marissa Rapaport, Joe Guan, Frank Barbour
https://my.up.ist.psu.edu/zog5064/main.php
IST210
18
And the winner goes to…
FoodFriend
Richard Kletter, Ryan Leckenby, Hope Wimer, Audra Stafursky
https://my.up.ist.psu.edu/aos5818/project/index.php
IST210
FINAL EXAM REVIEW
IST 210 Organization of Data
19
IST210
20
Exam Rules
• 1. The exam will be held at 8:00-9:50AM, on Friday
•
•
•
•
12/18/2015, in IST 110 (110 minutes). Try to come to
class at least 10 minutes early. Exam starts at 8AM.
2. The exam is close book. No computer or other digital
device is allowed.
3. You can bring one double-sided letter-size cheat sheet.
You should only have a pen or pencil, an eraser, and one
cheat sheet on your desk during the exam.
4. You should sit at your assigned seat during the exam.
The seat assignment will be displayed on the screen
before the exam.
5. Turn in your final exam paper AND the cheat sheet.
IST210
21
Exam Rules
•Academic integrity will
be strictly enforced.
IST210
22
Exam Content
• All the exam contents are covered in our slides. We will
not test the contents in the textbook but are not in slides.
However, if you have problems in understanding the
slides, you need to refer to the textbook.
• This exam will NOT test web-based programming (HTML
or PHP).
IST210
23
Exam Content
• Part 1. True or False. (1 point * 10 = 10 points)
• Part 2. Choose ONE from the multiple choices. (2 points * 10 = 20
points)
• Part 3. Normalize a relation (similar to Assignment 1 & 2 and part 2 in
midterm). (10 points)
• Describe the modification problems.
• List the candidate keys and functional dependencies in this relation.
• Is it a well-formed relation and why? If not, normalize this relation.
• Part 4. SQL (similar to Assignment 3 and Part 3 in Midterm). (25
points)
• Write SQL to create a table – cheat sheet is very important…
• Write SQL to insert data.
• Write SQL to answer queries.
IST210
24
Exam Content Continued
• Part 5. E-R diagram (similar to Assignment 4 and in-class
exercises of Ch. 4). (20 points)
• 1) Given the description of user requirement, draw the E-R
diagram.
• Entities
• Relationships
• Minimum/maximum cardinalities.
• Part 6. Database design (similar to Assignment 5 and in-class
exercises of Ch. 5). (15 points)
• 1) Given an E-R diagram, transform it into database tables.
• 2) Specify some properties for the attributes in the tables.
IST210
25
Exam Content Overview
• Part 1. True or False – all chapters. (1 * 10 = 10 points)
• Part 2. Multiple choices – all chapters. (2 * 10 = 20 points)
• Part 3. Ch2 Normalize a relation. (10 points)
• Part 4. Ch3 SQL. (25 points)
• Part 5. Ch4 E-R diagram (20 points)
• Part 6. Ch5 Database design (15 points)
IST210
26
Some Tips
• You should thoroughly understand every assignment. All
the assignment solutions are in ANGEL Lessons 
Solutions.
• You should go through all the examples, in-classes
exercises, and review questions in the slides.
• Do this in the slideshow mode: When you review
assignments or examples in slides, do NOT simply read
the answer. Try to re-do them, compare your answers with
the solution, and learn from the mistakes.
• You should put some SQL commands on the cheat sheet,
especially the template of creating tables (Be sure to
include referential integrity constraint statements… )
IST210
27
Chapter 1. Introduction to Database
• Problems with lists: redundancy, multiple themes,
modification issues (delete, update, insert)
• From list to relational database: Break into tables, and join
back using the value of the data
• Know how to query a relational database
IST210
28
Chapter 2. The Relational Model
• Know the characteristics of a relation
• Know the definitions and synonyms of Table, Row, and Column
• Understand the definitions of key, composite key, candidate
•
•
•
•
key, primary key, surrogate key, foreign key
Know the concept of referential integrity
Know the presentation of a relation with primary key (underline)
and foreign key (italic) – In the exam, use wave underline.
Understand functional dependency and definition of
determinant, know how to find functional dependencies in a
table.
Know the principles for normalization and know the steps for
normalization process (4 Steps)
IST210
29
Chapter 3. SQL
• The best way to review this chapter is to understand
every command in the slides and assignments.
• Do not only READ SQL. Reading SQL is easy. You have
to know how to WRITE SQL by yourself. Try to re-write
the SQL for the exercises in slides and assignment.
Compare your answer with the solutions to understand
the mistakes. It is important to learn from the mistakes!
• You should write down the SQL statements on the cheat
sheet if you think necessary.
IST210
30
Chapter 3. SQL
• Know how to create tables: (1) attribute definitions: data types, not
•
•
•
•
•
•
•
•
•
null, unique, default, identity; (2) how to define primary key, foreign
key; (3) referential integrity: delete/update cascade/no action. Know
what delete/update cascade/no action mean.
Delete a table: DROP
Know how to insert a data record using SQL. Pay attention to
surrogate key and null value.
SELECT…FROM…WHERE…
SELECT * , DISTINCT
WHERE: match criteria, AND, OR, IN, NOT IN, LIKE, wildcard, IS
NULL
Sort the results: ORDER BY … ASC/DESC
Know how to use the build-in functions: SUM, AVG, COUNT, MIN,
MAX
GROUP BY…HAVING…
Retrieve information from multiple tables: Subqueries and Joins
IST210
31
Chapter 4. E-R Diagram
• The best way to review this chapter is to re-draw the in-class
•
•
•
•
•
•
•
•
exercises in Chapter 4 and the case in assignment 4. Compare
your answer with the solutions.
Understand the purpose and role of a data model
Know the principal components of the E-R data model: entities,
attributes, identifiers,
relationships
Understand how to interpret and draw E-R diagrams
Know how to draw an entity including entity name, identifier,
and attributes. Strictly
follow the standard to the draw an entity
Know how to draw maximum cardinalities on relationships (1:1,
1:N, N:M)
Know how to draw minimum cardinalities on relationships
(optional and mandatory)
IST210
32
Chapter 5. Database Design
• The best way to review this chapter is to re-do the in-class
•
•
•
•
exercises in Chapter 5 and the case in assignment 5.
Compare your answer with the solutions.
Know how to transform an E-R diagram into relational
tables
Know how to transform entities to tables
Know how to transform 1:1, 1:N, and N:M relationships
Know how to specify the properties for the attributes in a
table. Pay attention to the properties of the foreign keys
IST210
Questions?
33
IST210
THANK YOU!
34