Populating the Database

·        If you are in Design View (the field name and properties appear), then click on the Datasheet button. Otherwise, just double-click the tables name in the main dialog. This will take you to the Datasheet view, where you can see the table you’ve just designed.  You will notice that it looks similar to Excel.  Like a spreadsheet, clicking on a cell and type in the information to enter data. You can switch between Datasheet and Design Views by the button- on the toolbar. On the main dialog box, double click on the Student table. This brings up the empty student table.

 

·        Save the table entries.

·        Enter the following data for the tables.

Table: Course

CID             Course Name

003               Physics-01

045               Database

810               English

 

Table: Professor

PID               First Name     Last Name

001               Adam           Hollioake

002                Ben             Hollioake

004                Jeff             Donahoo

 

Table: Takes

SSN      CID

1234     003

1234     045

1267     003

2000     003

2000     810

1345            045

 

Table: Taught

PID       CID

001       003

002       003

004       045

001       810

 

 

Main | Prev | Next