Transcript Materials on the first quiz

COSC 6340
MATERIALS ON
THE FIRST QUIZ
Jehan-François Pâris
Spring 2015
Overview






Simple SQL queries
 (without special keywords and so on)
The entity-relationship model
Data normalization (refer to notes)
Storage devices (refer to notes)
Indexing (refer to notes)
Query optimization (notes are in progress)
Hints



I like to ask
 Short problems
 Questions on advantages and disadvantages
of specific solutions
I never ask questions requiring very long
developments
My objective is to test that you can put to work
the concepts you have learned
Some ideas




Given the two tabled STUDENT and
4330_FALL14, find all graduate students who
got at least a B+
Given an ER model, design an SQL database
that satisfy all normalization criteria
Explain why this specific table cannot be put in a
given normal form without a loss of information
What is the cost of switching between two
platters within the same cylinder of a disk?
Some ideas





Why does writing to a flash drive tke more time
than reading from it?
What are the advantages/disadvantages of
spanned records?
What are the advantages/limitations of sparse
primary indexes?
Why are B+ trees better than B trees?
Optimize a given query
Academic honesty

No cheating or plagiarism will be tolerated in
any quiz

The minimum penalty for any transgression
will be an F grade for the course
You have
been
warned!
Unless you want to fly back
home …
YOUR NAME
HOUSTON IAH
YOUR NAME
HOME TOWN
HOME TOWN
Your family will be so proud of
you!