Page 306 - TP_IT_V1.0_C10_flipbpookl
P. 306
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 questions 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
OPENING A DATABASE
Follow the given steps to open an already created database:
Step 1: Select the File → Open option from the Menu bar.
The Open dialog box open.
Step 2: Navigate the location where the database is stored.
Step 3: Select the desired database that you want to open.
Step 4: Click on the Open button.
The selected database gets opened.
304 Trackpad Information Technology (Ver. 1.0)-X

