SQL Data Definition

Preparation

Fundamentals of Database Management Systems

• Chapter 7: Logical Database Design
  • Building the Data Structure with SQL
  • Manipulating the Data with SQL

Learning Objectives

• Create a relational database using the CREATE TABLE SQL command
• Select appropriate data types for attributes in relations
• Manipulate data using the following SQL commands:
  • INSERT
  • UPDATE
  • DELETE