Question & Answer

Question 1

a) What is the defination of relational & why it is needed?
Relational key are device that relates one entity with another entity in relationship. A key consist of one or more attributes that can be identified in a row and enables us to link the table together in database for easier data access storage.

b) List and explain 4 type of relational keys.
i. Candidate Key
- an attribute or group of attribute that identify a unique row in a relation.
ii. Primary Key
- any of the candidates that are selected to be the key or an attribute that uniquely identifies each row in a relational table.
iii. Foreign Key
- an attribute in one table whose values must match the primary key in another table or whose value must not null.
iv. Composite Key
- a primary key that consists of more than one attribute, especially in (M:N) relationship.

c) Based on table given below, answer all the following question:

i) What is the name for the above table? BORROWER

ii)What is the primary key for above table?
BORROWER_ID

iii) What is data type for borrower's name, category, age and date of birth colum?

1. BORROWER NAME- text
2. CATOGERY- text
3. DATE OF BIRTH- date/time
4. AGE- number

iv) How many attributes and records contains in the table?

1. attributes- 7
2. records- 2

v) What is the function of field size, input mask and default value?

1. field size- the maximum number of character you can enter in the field.
2. input mask- a pattern for all data to be entered in this field.
3. defult value- a value that automatically entered in this field for new records. 

 Question 2

Question 3

Question 3

Question 4

Question 5

Question 6

Query

 Creating Select Queries As the Select query is the most common queries and frequently used, the Select Query normally be referred to as a 'query'.

Creating Queries with the Query Design The process of making queries to the Query Design started by clicking the Query Design above.
The data used were:Customer
 
Cust_No
Cust_Name
Cust_Address
Cust_Mobile

Product
ID_Product
Product_Name

Booking
BookingNo
Book_Date
Price_Per_Unit
Quantity
Grant_Total










Drop down selected Primary Key

Save As

Relationship Within The Table.

Primary Key
The key is called the primary key.With the primary key, even if there is a record in other fields of the twin.This record is still a different record.

Foreign Key
Foreign keys are essentially "opposite" of the primary key. Primary key is the parent table and foreign keys are in the child table.

TYPES OF RELATIONSHIP

> One-to-one (1:1)
> One-to-Many (1:M)
> Many-to-One (M:1)
> Many-to-many (M:N)

Table & Design View

1) Firstly,use the Mode Design View,make the table structure first.

2) Make sure that you have activated the Mode Design View.

3) Rename the table and Save Ass.

4)The below side is use to organize property from the type field that has been choosen.

Starting On How to use Microsoft Access

STARTING USING MICROSOFT ACCESS :

1.Click start button
2.Go to All programs in Start menu.
3.Find Microsoft Office application and click
4.Click Microsoft Access 2007 in program list

1. Start Access
2. Click Blank Database icon
3. Type the name that u want for database in File NAME.
4. Click the Browse button and the File New Database will appear at the screen.
5. Place the folder where do you want to put.Type your file name in File space.
6. Click ok
7. Click  Create button