1 / 10

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. Chapter 7. Chapters 1, 2, 3 & 5.

isaiah
Download Presentation

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

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. Midterm ExamChapters 1,2,3,5, 6,7(closed book) March 11, 2014

  2. COP4710 Midterm Exam • Part 1: Database Application Development • Part 2: Theory and Database System Internal

  3. 3-Tier Architecture Chapter 7 Chapter 7 Chapters 1, 2, 3 & 5 Chapter 6

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

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

  6. Chapter 3: Relational Model • Basic concepts: relationand 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

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

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

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

  10. Study Time Required Grades

More Related