Question

create a database ‘Friend’s Record’. Table name as ‘My Friends’. Field names as- Roll no, Name, Address, Age, City, Mobile no. Set primary key. Create a query to find the records having birthday in the next month.
Create a report to displays the friend’s detail.

Answer 1

Answer:

CREATE TABLE My Friends

(

RollNo INT primary key,

Name Varchar[20],

Address Varchar[20],

Age INT,

city Varchar[20]

Mobile_no INT,

);