This is based on the implementation of database on email application in which a database is created based on the information provided by the user of email system and provided an interface between user and database system by the means of front end.
For the implementation of such definition we have first created the database schema based on the requirements of our database which defines the basic structure of the database and tells something about data model definitions.
According to our data needs we have divided our database into five relations, the relations and their attribute are create as per shown below.
- User: (User_id, Password)
- Name: (First_name, Middle_name, Last_name, User_id)
- Address: (Address, city, state, country, pin_code, User_id)
- Personal: (date_of_birth, age, gender, User_id)
- Contacts: (Mobile_no, Landline_no, User_id)
- Services: (Google+, Google_drive, User_id)