cis3730_Exam1_Studyguide
Exam 1 Overview:
Exam Date: Monday, Oct 6. The total time is 1 hour and 30 minutes.
Closed book, closed note, no computers, no calculators. No collaboration allowed.
Exam Format:
Multiple choice questions
Some "open" short-answer questions;
A E-R modelling case
Notice that almost all "open" short-answer questions call for a definition (formal) or description (informal) of a topic covered, and also require you to provide an example of the concept. So, as you study each question below, consider the definition and have an example in mind.
Following are just the key points to help you prepare the exam. You need to read ALL the slides (except the hidden pages).
Week 1 and 2
Can describe and explain the components of a database system. You should be able to give examples of a database system and specify the components of that particular system.
Database
Understand the key characteristics of databases.
What are primary keys, surrogate keys and foreign keys?
Be able to give examples of tables, specify their primary keys, and explain how they are related through foreign keys.
Given a table or a set of tables, be able to specify their primary keys and foreign keys.
What are metadata?
Understand the definition and use of DBMS. Be familiar with major DBMS products.
Week 3
Understand what SQL stands for, what it does.
You will be asked to write SQL scripts to display required information, like we did in the homework.
Understand the three components of a basic select statement and what do they mean (select, from, where).
Week 4 and Week 5
Understand the concepts of conceptual model,
Entities: a name singular noun, descriptive and specific, concise
Attributes:
Relationships: is a collection of data organized based on a model derived from 1st order predicate logic
Be able to determine different types of relationships.
One-to-one
One-to-many
Many-to-many
Zero-to-many
Zero-to-one
Given a business problem, you will be asked to construct an
Exam Date: Monday, Oct 6. The total time is 1 hour and 30 minutes.
Closed book, closed note, no computers, no calculators. No collaboration allowed.
Exam Format:
Multiple choice questions
Some "open" short-answer questions;
A E-R modelling case
Notice that almost all "open" short-answer questions call for a definition (formal) or description (informal) of a topic covered, and also require you to provide an example of the concept. So, as you study each question below, consider the definition and have an example in mind.
Following are just the key points to help you prepare the exam. You need to read ALL the slides (except the hidden pages).
Week 1 and 2
Can describe and explain the components of a database system. You should be able to give examples of a database system and specify the components of that particular system.
Database
Understand the key characteristics of databases.
What are primary keys, surrogate keys and foreign keys?
Be able to give examples of tables, specify their primary keys, and explain how they are related through foreign keys.
Given a table or a set of tables, be able to specify their primary keys and foreign keys.
What are metadata?
Understand the definition and use of DBMS. Be familiar with major DBMS products.
Week 3
Understand what SQL stands for, what it does.
You will be asked to write SQL scripts to display required information, like we did in the homework.
Understand the three components of a basic select statement and what do they mean (select, from, where).
Week 4 and Week 5
Understand the concepts of conceptual model,
Entities: a name singular noun, descriptive and specific, concise
Attributes:
Relationships: is a collection of data organized based on a model derived from 1st order predicate logic
Be able to determine different types of relationships.
One-to-one
One-to-many
Many-to-many
Zero-to-many
Zero-to-one
Given a business problem, you will be asked to construct an