Draw a database diagram for the script file named create_mgs_tables.sql (see Attachment)following is the attachment (copy pasting from notepad

   

Transcribed Image Text:

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; 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;

Answer rating: 100% (QA)

Solution 1 Database Diagram 8 categories PK categoryid 2 categoryname 1 Database Diagram User M u... View the full answer