Transcript Midterm Exam Chapters 1,2,3,5, 6,7 (closed book)

Midterm Exam
Chapters 1,2,3,5, 6,7
(closed book)
March 11, 2014
COP4710
Midterm
Exam
• Part 1: Database Application
Development
• Part 2: Theory and Database
System Internal
3-Tier Architecture
Chapter 7
Chapters
1, 2, 3 & 5
Chapter 6
Chapter 1: Introduction to
Database Systems
• Why use a DBMS ?
• What is a data model ?
• 3-layer architecture: physical schema, conceptual
schema, views
• Concurrency control and transaction processing
Study Time: 2 hours
Chapter 2: Conceptual Design
• ER model
• Entity set
• Relationship
• Key constraint, i.e., 1-to-many relationship
• Participation constraint: total vs partial
• ER design considerations
• Entity vs attribute
• Binary vs ternary relationship
Study Time: 2 hours
Chapter 3: Relational Model
• Basic concepts: relation and tuple
• Create relations using SQL
• create relations
• add and delete tuples
• specify constraints: primary key constraint,
referential integrity constraint
• create views
• ER diagram to SQL mapping
Study Time: 2 hours
Chapter 5: SQL
• Semantics of SQL:
SELECT … FROM … WHERE … GROUP BY … HAVING …
• How to write queries
• Basic SELECT-FROM-WHERE queries
• Queries with set operators such as UNION,
INTERSECT, and EXCEPT
• Nested queries
• Queries based on the Division operation
• Queries with aggregate operators
• General constraint (in a relation) & assertion
(over multiple relations)
• Triggers
Study Time: 3 hours
Chapter 7: Internet Computing
• Web data format: HTML, XML, DTD
• 3-tier architecture
• Presentation tier: HTML Form, Javascript, Stylesheet
• Application tier
• CGI,
• Application Servers, Servlets (Code first, webpage
second)
• JavaServerPages (Webpage first, code second)
• Maintaining state: Cookies, hidden fields (in forms),
extra path information
Study Time: 4 hours
Chapter 6: Internet DB Apps
• Embedded SQL and Cursor
• Dynamic SQL using PREPARE and EXECUTE statements
• JDBC (java.sql package)
• Four types of JDBC drivers
• Load driver, connect to data source, execute SQL statements (using
Statement object, PreparedStatement object, or CallableStatement
object)
• Transaction processing in JDBC
• Exception and warning
• DatabaseMetaData Object (for catalog information)
• SQLJ - Similar to embedded SQL; but using industry-standard
interface
• Stored procedures: Writing stored procedure using SQL/PSM,
how to call stored procedure from JDBC and SQLJ
Study Time: 4 hours
Study Time Required
Task
Time Required
Study 400 pages of Powerpoint slides
Practice the homeworks
Practice the SQL examples in textbook
TOTAL TIME NEEDED
Grades
A: 90 ~ 100
17 hrs
3 hrs
4 hrs
24 HRS
Excellent
B: 80 ~ 89.99 Good
C: 70 ~ 79.99 Can be improved
D: 60 ~ 69.99 Need to spend more time on the final
F: < 60