Question: Draw a database diagram for the script file named create_mgs_tables.sql (see Attachment)following is the attachment (copy pasting from notepad CREATE TABLE administrators ( admin_id email_address
Draw a database diagram for the script file named create_mgs_tables.sql (see Attachment)following is the attachment (copy pasting from notepad
CREATE TABLE administrators ( admin_id email_address password first_name last_name VARCHAR2(255) PRIMARY KEY, NOT NULL, NOT NULL, VARCHAR2 (255) VARCHAR2(255) NOT NULL, VARCHAR2 (255) NOT NULL NUMBER ); -- Disable substitution variable prompting SET DEFINE OFF; -- Insert data into the tables INSERT INTO categories (category_id, category_name) VALUES (1, 'Guitars'); INSERT INTO categories (category_id, category_name) VALUES (2, 'Basses'); INSERT INTO categories (category_id, category_name) VALUES (3, 'Drums'); INSERT INTO categories (category_id, category_name) VALUES (4, 'Keyboards'); CREATE SEQUENCE category_id_seq START WITH 5;
Step by Step Solution
There are 3 Steps involved in it
Solution 1 Database Diagram 8 categories PK categoryid 2 categoryname 1 Database Diagram User M u... View full answer
Get step-by-step solutions from verified subject matter experts
