Page 269 - Trackpad 402_Class-X_Final
P. 269
A new database with the name - School.odb is created with the objects -Tables, Queries, Forms and Reports.
The given database window opens:
Table: STATIONARY
uiz Bee
SID SNAME COMPANY PRICE STOCKDATE
DP01 Pen ABC 10 2011-03-31
PL02 Pencil XYZ 6 2010-01-01
ER03 Eraser XYZ 7 2010-02-14
PL01 Pencil CAM 5 2009-01-09
GP02 GelPen ABC 15 2009-03-19
Table: CONSUMER
CID CNAME ADDRESS SID
01 Good Learner Delhi PL01
06 Write Well Mumbai GP02
12 Topper Delhi DP01
15 Write & Draw Delhi PL02
16 Motivation Bengaluru PL01
Answer the following based on the above tables:
a. Identify the Primary Key for the tables STATIONARY and CONSUMER
b. Identify the Alternate Key of the table CONSUMER
c. Identify the Candidate Keys of the table STATIONARY
d. Identify the Foreign Key of the table CONSUMER
STEPS TO CREATE A TABLE
To create a table, select the Table option in the Database list. In the OpenOffice Base there are two different methods
used to create a table.
Database Management System 269

