'Rimary key' presentation slideshows

759 views • 66 slides

Unit 4 Logical Database Design

Unit 4 Logical Database Design. Contents. 4.1 Introduction 4.2 Functional Dependency 4.3 First, Second, and Third Normal Forms (1NF, 2NF, 3NF) 4.4 Boyce/Codd Normal Form (BCNF). 4.1 Introduction. Logical Database Design vs. Physical Database Design Problem of Normalization

603 views • 38 slides

DBS201: More on SQL

DBS201: More on SQL. Lecture 2. Agenda. Review How to create a table How to insert data into a table Terms Lab 2. Review. Data Anomalies What is a database? What is a DBMS? What are three categories of SQL statements Use three letters to describe each category On IBM i platform

400 views • 29 slides