Consider the Company example that we are using in our textbook. The complete relational schema for this
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider the Company example that we are using in our textbook.
The complete relational schema for this scenario. Using this code provided below build this schema. Perform the following steps:
Show the list of tables (there should be none) before executing the six scripts using "SHOW TABLES" .
DROP TABLE department; CREATE TABLE department ( dname varchar(25) not null, dnumber integer(4), mgrssn char(9) not null, mgrstartdate date, primary key (dnumber), key (dname) );
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: