In this lesson, you will learn to: Identify the following kinds of relations: Base tables Query results Views Create tables Alter tables Remove tables Query tables and work on them Define views Perform DML operations on views Identify the different types of views Identify data integrity constraints. | J Lesson 3A Physical Database Design Objectives In this lesson you will learn to 5 Identify the following kinds of relations Base tables Query results Views 5 Create tables 5 Alter tables 5 Remove tables 5 Query tables and work on them 5 Define views 5 Perform DML operations on views 5 Identify the different types of views Ỡ Identify data integrity constraints Relational Database Design Physical Database Design Objectives In this section you will learn to Identify the following kinds of relations Base tables Query results Views Create tables Alter tables Remove tables Query tables and work on them Define views Perform DML operations on views Identify the different types of views Identify data integrity constraints NIIT Physical Database Design Lesson 9 Slide 1 of 13 INSTRUCTOR Notes Lesson Overview The lesson covers the different kinds of relations. It also explains how to create alter remove and query tables. In addition the lesson explains the different types of views the various DML operations that can be performed on them and data integrity constraints. Nirr Relational Database Design Physical Database Design Pre-assessment Questions 1. Functional dependencies represent relationships. 2. What is the term used for the intentional introduction of redundancy in a table in order to improve performance 3. Each value of an attribute A in relation R is associated with precisely one value of attribute B. What is this called 4. A table is said to be in the when each cell of the table contains precisely one value. 5. In a relation every determinant is a candidate key. This relation is in which normal form NIIT Physical Database Design Lesson 9 Slide 2 of 13 Relational Database .
