Question

11. Create two tables with the following information: Table Event: Each event has a unique event ID like 123, a date, and a location when the event was held, and a menu ID of the menu that was served in the event. In each event, exactly one menu is provided. Table Menu: Each menu has a unique menu ID like 45, a description of the menu, and the type of the menu.

REQUIREMENTS: • You MUST LIST your CREATE TABLE statements in the CORRECT ORDER, MEANING o The two tables can be actually created without any error when running the two statements in that listed order. • You MUST DEFINE NECESSARY CONSTRAINTS such as primary key, foreign key, etc.

HINTS: • One table is the parent table. The other table is a child table. • Create the parent table before the child table.

12. Write two DDL statements to drop the two tables you created in 11.

REQUIREMENT • You MUST LIST your DROP TABLE statements in the CORRECT ORDER, MEANING o The two tables can be actually dropped without any error when running the two statements in that listed order.

HINTS: • One table is the parent table. The other table is a child table.

• Drop the child table before the parent table.

Answer 1

Hi,

Solution of 11

CREATE TABLE Event(
EventID int NOT NULL,
EventDate varchar(255) NOTNULL,
Eventlocation varchar(255),
MenuID int NOT NULL,
    PRIMARY KEY (EventID)
);

CREATE TABLE MENU (
MenuID int NOT NULL,
MenuType varchar(255) NOT NULL,
MenuDescription varchar(255) NOT NULL,
    PRIMARY KEY (MenuID),
    FOREIGN KEY (EventID) REFERENCES Event(EventID)
);

Solution of 12

DROP TABLE MENU;

DROP TABLE EVENT;