1 / 9

COSC 6340 MATERIALS ON THE FIRST QUIZ

This resource provides an overview of the topics covered in the first quiz of the COSC.6340 course, including SQL queries, entity-relationship model, data normalization, storage devices, indexing, and query optimization. It also includes hints, short problems, and questions to test your understanding of the concepts learned.

williamphoward
Download Presentation

COSC 6340 MATERIALS ON THE FIRST QUIZ

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. COSC 6340MATERIALS ONTHE FIRST QUIZ Jehan-François Pâris Spring 2015

  2. 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)

  3. 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

  4. 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?

  5. 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

  6. 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

  7. You havebeen warned!

  8. Unless you want to fly back home … YOUR NAME HOUSTON IAH HOME TOWN HOME TOWN YOUR NAME

  9. Your family will be so proud of you!

More Related