This preview shows page 1. Sign up to view the full content.
Unformatted text preview: employees. The employee entity is related to itself, and there is a one-to-many relationship between one employee and many other employees 3. Heres a little challenge to start working ahead. Use the entity drawing below as the basis for writing a CREATE TABLE statement in SQL. You might want to use pp. 239 249 in the text. Note that you only need to create the table and its columns; you dont need to create any constraints for this assignment. Your answer will be an example of a CREATE TABLE statement. CREATE TABLE Course ( Course_No NUMBER PRIMARY KEY Course_Name VARCHAR NOT NULL Credit Hours CHAR (1) NOT NULL )...
View Full Document
- Spring '11