Question: Build a simple phone book management database in which you can store the information of different persons. The detailed experimental plans are as follows: Experiment
Build a simple phone book management database in which you can store the information of different persons. The detailed experimental plans are as follows: Experiment 1: Database Schema Definition The database schema consists of two relations; Person, and Phone Book. The Persons relation should store ID, Name, Gender, Age, and Address. The phone book relation should store Unique Person ID, Phone#, and Email. The Schemas should assign appropriate Primary Keys and Default values if any. Requirements: 1. Identify the relations and corresponding attributes from the above statement. 2. Choose appropriate names for relations and attributes (should be meaningful and short). 3. Insert some dummy data into your relations that can satisfy below queries. a. Show person(s) whose Age is less than 18 years. b. Show a person Name, Age, and phone number by combining both relations. Additional: 1. You are free to choose any tool to build your database and practice these experiments. 2. You are required to provide schemas for your Database in the form of a word document consisting of linear notation and SQL Queries. Hints: Lecture 1-5. Note: . Do it according to your understanding, (Do not copy from others) Provide reference if you learn or use some matrial for the internet. The deadline for this assignment is 31 March 2022 Build a simple phone book management database in which you can store the information of different persons. The detailed experimental plans are as follows: Experiment 1: Database Schema Definition The database schema consists of two relations; Person, and Phone Book. The Persons relation should store ID, Name, Gender, Age, and Address. The phone book relation should store Unique Person ID, Phone#, and Email. The Schemas should assign appropriate Primary Keys and Default values if any. Requirements: 1. Identify the relations and corresponding attributes from the above statement. 2. Choose appropriate names for relations and attributes (should be meaningful and short). 3. Insert some dummy data into your relations that can satisfy below queries. a. Show person(s) whose Age is less than 18 years. b. Show a person Name, Age, and phone number by combining both relations. Additional: 1. You are free to choose any tool to build your database and practice these experiments. 2. You are required to provide schemas for your Database in the form of a word document consisting of linear notation and SQL Queries. Hints: Lecture 1-5. Note: . Do it according to your understanding, (Do not copy from others) Provide reference if you learn or use some matrial for the internet. The deadline for this assignment is 31 March 2022
