Get 2 days of premium access
at Georgia Institute of Technology

Textbook Notes for monicasweat

GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 15: Joule, Xu, Fifth Normal Form

OC16671226 Page
0
Functional dependencies: inference rules, equivalence and minimal cover. Set of attributes x functionally determines a set of attributes y if the value
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 2: Diagram, Concurrency Control, Query Language

OC16671228 Page
0
Client/server dbms architecture, system functionality is distributed between two types of modules. Client module: designed to run on a user workstation
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 9: Surrogate Key, Unique Key, Foreign Key

OC16671223 Page
0
For each regular/strong entity type, create a relation r that includes all the simple attributes. Choose 1 key attribute as the primary key for the rel
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 6: Pattern Matching, Boolean Data Type, Relational Model

OC16671227 Page
0
Origin of sql is relational predicate calculus/tuple calculus which was initially proposed as square. From sequel to square to structured query languag
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 7: Railways Act 1921, Materialized View, Data Definition Language

OC16671228 Page
0
Each individual null value can be considered different than all other. Query to check whether or not a value is null. Insert another select-from-where
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 14: Multivalued Dependency, Unique Key, Fifth Normal Form

OC16671226 Page
0
Basics of functional dependencies and normalization for relational databases. Formal concepts of functional dependencies and normal forms. Semantics of
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 8: Railways Act 1921, Xu, Thx

OC16671229 Page
0
Chapter 8: the relational algebra and relational calculus. Operations used to specify basic retrieval requests (queries) Result of an operation is a ne
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 5: Superkey, Referential Integrity, Data Integrity

OC16671226 Page
0
Chapter 5: the relational data model and relational db constraints. Relational model of data is based on concept of relation. Model first proposed by d
View Document
GEORGIA TECHCS 4400monicasweatFall

CS 4400 Chapter Notes - Chapter 1: Time Series, Data Mining, Xml

OC16671229 Page
0
Db application in which most of information stored and accessed is either textual or numeric. Db application that lets you store images, audio clips an
View Document
Showing 1 — 9 of 9 result

Textbook Notes (270,000)
US (100,000)
CS (20)
monicasweat (9)