Question

"ABC" Event Management Company requires data of events that are to be organized. Write SQL query to create a table 'Event' with the following structure:

Field	Type	Constraint
EventId	Integer	Primary key
Event	Varchar (50)
DateEvent	Date
NumPerformers	Integer

Comments

from which book this question is putted up?

---

CBSE AISSCE 2017 Sample Paper

Answer 1

CREATE TABLE Event

(

EventId INT,

EVENT VARCHAR(50),

DateEvent DATE,

NumPerformers INT,

PRIMARY KEY(EventId)

);