CS338 Final: Study Guide for Final Exam CS338.pdf

• School: University of Waterloo
• Department: Computer Science
• Course: CS338
• Professor: Khuzaima Daudjee

Document Summary

Data abstraction allows the above two: conceptual representation of data = no details of how data is stored or implementation of operations. Dba = authorize, coordinate, acquire; db designer = identify, choose stuctures; Chapter 2 : dbms: client/server architecture chef/customer relationship, data models = collection of concepts that describe a database"s structure. Allows data abstraction, basic operations, and set state validity. 3 categories: low/physical (detailed) [uses access paths and indices], high/conceptual (usual) and representational (end users) Chapters 7 to 10 : mapping algorithms: 9-step mapping algorithm = (1) map regular entities (2) map weak entities (3) map 1:1 relations (4) map 1:n relations (5) map. Structural types include (1) class diagrams / package diagrams (2) object diagrams (3) component diagrams (4) deployment diagrams. Behavioural types include (1) use case diagrams (2) sequence diagrams (3) collaboration diagrams (4) statechart diagrams (5) activity diagrams: semantic web = helps to interpret the meaning of the data.