csc408 management information system creating web viewcomplete your biscuit table structure as shown...
TRANSCRIPT
CSC408 Management Information System Creating Database & Tables
Creating Database with graphical design facilities in Access DBMS
1. Create database name: biscuitDB
SNI2012 Page 1
Blank database: Choose this icon to create a
new MS Access database that do not contain any existing data or object.
Save database: You MUST SAVE the
database first before start working with it.
Save your database as biscuitDB.accdb
Open icon:This icon is use for specifying the location of
the database to be created.By default, new database will be created in
My Documents folder.Select your pendrive as the location to create
your database.
Database name:This text filed is where you type
down the database name to be created. the extension database file for MS Access 2007 is .accdb
You database name will be biscuitDB
CSC408 Management Information System Creating Database & Tables
Creating Tables with graphical design facilities in Access DBMS
1. Open database biscuitDB.2. To create a new table, select ribbon Create Table.
3. A new table dialog box will appear. Save the table as biscuit.
4. Now you have a table object named biscuit. Right Click the table object, and then select design view in order to construct the table structure.
5.
Complete your biscuit table structure as shown below:
SNI2012 Page 2
Design View: View used to define
attribute, primary key, data type and description of a table.
Primary key: This is the icon to
define primary key. It is a unique attribute
to identify each table.
Field name: Attribute of a
table is defined here.
Data type: Data type of
attribute is defined here.
Select data type by scrolling the drop down list.
CSC408 Management Information System Creating Database & Tables
Table biscuit
6. Create customer and order tables as shown below:
Table customer
Table order
7. Make sure each of you table have a primary key.
Primary and Foreign Keys
Primary Key is a field (or a combination of fields) that uniquely identifies any given row.
In the example above, the primary key for table biscuit is bisID, the primary key for table customer is custID and the primary key for table order is orderID
Foreign Key is a field whose values match primary key values in the related table
In the example above, if you look closely at table order, the fields custID and bisID appear there, as well as in their own respective tables. These fields are the primary key in their own tables, but in table order, they are considered Foreign Keys.
SNI2012 Page 3