Database Exercise

Database exercise

1. Create a new database with the name (Manar)
2. Create a new table with the name (Personal data), then add the following fields:

Field name	Data type	Properties
S_code	Short Text	Begins with a capital letter, followed by 3 digits
S_name	Short Text	Maximum 20 Characters
Gender	Short Text	One letter M or F
DOB	Date/Time	before todays date with the format MMM dd, yyyy
Telephone	Short Text	3 digits between 2 brackets followed by a space then 8 digits (000) 00000000

 

3. Create a new table with the name (Books), then add the following fields:

Field name	Data type	Properties
ISBN	Short Text	Begins with ISBN followed by a space the 6 digits
Book_title	Short Text	Maximum 30 characters
Publisher_code	Short Text	Begins with one capital letter followed by a dash then 3 digits

 

4. Create a new table with the name (Users), then add the following fields:

Field name	Data type	Properties
User_id	Short Text	Begins with a capital letter, followed by 3 digits
Password	Short Text	A password like (******) , accept at least 6 characters and max 8 characters
Email	Short Text	Accept email format

 

5. Import the file Holidays.csv

• Examine and assign suitable data types for the fields
• Add a validation rule to only accept data in End_date field which after the Start_date only
• Add the following record:

Dcode	Destination	Start_date	End_date
D11	Italy	01/04/2018	10/04/2018

• Create a new report to show all holidays begins during February and March only
• Add a new field called Duration which will be calculated at run-time to show each holiday duration, format this field as a number without any decimal places.
• Show all the fields in the Holidays table
• Show today’s date and time on the bottom left corner

Save your work, send your database as an attachment to your teacher’s email.

Good luck