Thư viện tri thức trực tuyến
Kho tài liệu với 50,000+ tài liệu học thuật
© 2023 Siêu thị PDF - Kho tài liệu học thuật hàng đầu Việt Nam
Bài tập câu hỏi trắc nghiệm SQL
Nội dung xem thử
Mô tả chi tiết
Exercise 1
Q1
ONLINE CONTESTS system organises contests on various topics. Each contest on a
particular topic has a set of 5 questions to be answered, and is sponsored by a company.
The following tables are maintained within database by the system :
Table : CONTEST Table : COMPANY
Column Description Column Description
contest_cd
contest_des
clos_dt
comp_cd
Contest code.
Name and description.
Closing date.
Sponsoring company code.
comp_cd
comp_nm
address
tel_no
cont_per
Company code. (PK)
Company name.
Address.
Telephone number.
Contact person’s name.
Table : QUES_ANS Table : CON_ANS
Column Description Column Description
contest_cd
ques1
ans1
ques2
ans2
ques3
ans3
ques4
ans4
ques5
ans5
Contest code.
Question 1.
Answer 1.
Question 2.
Answer 2.
Question 3.
Answer 3.
Question 4.
Answer 4.
Question 5.
Answer 5.
con_cd
contest_cd
ans1
ans2
ans3
ans4
ans5
Contestant code.
Contest code.
Answer 1.
Answer 2.
Answer 3.
Answer 4.
Answer 5.
Table : CONTESTANT
Column Description
con_cd
con_nm
e_mail
dt_of_entry
Contestant code.
Contestant name.
E-mail address.
Date of entry.
a) Create tables CONTEST, COMPANY, QUES_ANS, CON_ANS, and CONTESTANT
b) In COMPANY table, column comp_cd, system generated sequential values like
1000,1002,1004,1006, … will be added at the time of record addition.
c) Add few required records to those tables.
Notice: PK: Primary key