Sharon Dow

Generate statements (ddl) to create all objects

DDL Statements to create objects:

  • October 24, 2018 at 1:07 PM
  • Visible to public
DDL Statements to create objects:     create or replace table teacher (     teach_id int primary key,     name varchar(50),     salary decimal(6,0)     );     create or replace table grade (     id int primary key,     student_id int,     teacher_id int,     term_id int,     grade_varchar varchar(40),     grade_num int,     status varchar(10),    subject_id int,    foreign key (teacher_id) references teacher(teach_id),     foreign key (student_id) references student(student_id),     );   create or replace table student (     student_id int primary key,     student_name varchar(40),     creditsearned decimal(5,2),    dob datetime     );     


https://parkland1-my.sharepoint.com/:w:/r/personal/sdow3_stu_parkland_edu/_layouts/15/Doc.aspx?sourcedoc=%7B9ADBB784-B847-4BF0-BE34-1D06976E186B%7D&file=Module%201_%20CSC176%20Data%20Systems_Sharon%20Dow%20102318.docx&action=default&mobileredirect=true