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. Here’s 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 don’t 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
- recursive relationship, _________Arnold Ruzvidzo___ Date, onetomany recursive relationship