Exams are coming!
Get ready with premium notes and study guides!

Class Notes for CMPSC 431W at Pennsylvania State University (PSU)

  • 15 Results
  • About PSU
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture Notes - Lecture 8: Positional Notation, Operand, Binary Operation

OC12777244 Page
16 Feb 2019
0
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture Notes - Lecture 9: Functional Dependency, Unique Key, Candidate Key

OC12777243 Page
30 Mar 2019
0
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture Notes - Lecture 13: Database, Storage Record, Database Engine

OC12777245 Page
6 May 2019
0
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture 12: Lecture 12

OC12777242 Page
30 Mar 2019
0
Uniform resource identifiers: a set of strings that references certain resources. Has three parts: protocol to access the resource (http, name of the h
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture Notes - Lecture 2: Logical Data Model, Physical Data Model, Relational Model

OC12777243 Page
16 Feb 2019
0
Example: students (sid: string, name: string, login: string, age: integer, gpa: real) External schema: describes how user see the data. Allows data acc
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture Notes - Lecture 6: Candidate Key, Unique Key, Database

OC12777241 Page
16 Feb 2019
0
Super key: a set of fields that contains a key, a tuple is always a super key. Only one candidate key is chosen to be the primary key. Dbms may create
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture 7: Lecture 7

OC12777245 Page
16 Feb 2019
0
Insert a tuple with studid 53600: reject because there is no id of 53600 in the parent table. Update the tuple with studid = 53650 -> 53666: we can do
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture 1:

OC12777241 Page
16 Feb 2019
0
It maintains a very large, integrated collection of data. A database models a real-world enterprise by using two components. Database management system
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture Notes - Lecture 15: Serializability, Institute For Operations Research And The Management Sciences, Oracle Database

OC12777242 Page
6 May 2019
0
An application program with special properties to guarantee it maintains database correctness. Many applications use databases to store information abo
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture Notes - Lecture 14: Query Optimization, Relational Algebra, Relational Database

OC12777244 Page
6 May 2019
0
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture 10: Lecture 10

OC12777245 Page
30 Mar 2019
0
View Document
PSUCMPSC 431WWang-Chien LeeSpring

CMPSC 431W Lecture 11: Lecture 11

OC12777242 Page
30 Mar 2019
0
Sql commands can be called from within a host language like c++ and java. Techniques for sending sql statements to the db: Embedded sql: method of comb
View Document
Showing 1 — 12 of 15 results
View all professors (1+)

Class Notes (1,100,000)
US (460,000)
PSU (8,000)
CMPSC (30)
CMPSC 431W (10)