Question
Problem: Design and implement a simple phone book (PL/SQL) application that stores and manipulates contacts and their phone numbers. Requirements specification: The system to be
Problem: Design and implement a simple phone book (PL/SQL) application that stores and manipulates contacts and their phone numbers. Requirements specification: The system to be designed and implemented is a phone book that deals with contacts data and their phone numbers, similar in functionality to contacts apps found on smartphones. The system should be able to record and manipulate (create, read, update and delete) data about contacts and their phone numbers. The following information and constraints should be captured in the application: Each contact is uniquely identified in our phone book by ids. Ids are represented as integers (e.g. 1, 2, 3,). Contacts have names. Names are represented as strings (e.g. John). For each contact a name must be recorded (e.g. contact with id 3 has name John). Each contact has exactly one name (e.g. contact with id 3 cannot have two names John and Alex). It is possible that more than one contact has the same name (e.g. it is possible that contact with id 2 is called John and contact with id 3 is also called John). Each contact-name combination is unique (e.g. the fact that contact with id 3 has name John cannot be recorded multiple times). Contacts have phone numbers. Phone numbers are represented as integers (e.g. 99224434). Each contact may have zero or more phone numbers recorded (e.g. mobile or landline). It is possible that for some phone number, more than one contact has that phone number. Each contact-phone number combination is unique. The system should be able to support manipulation of contacts and their phone numbers: Create (e.g. create contact with id 1, name John, and phone 92838493). Update (e.g. change the name of contact 1 from John to Joe and his phone 92838493 to 99776611). Delete (e.g. remove contact with id 1 or and all the phone numbers associated with that contact). In addition, the system should be able to support querying contacts data. Examples of queries to be supported include: What contacts are registered in the phone book? What are the contacts whose name start with a given letter? What are the contacts that have a given phone number? What are the contacts that have at least one phone number registered? What are the contacts that have no phone numbers registered? What are the contacts that have at least a given number of phone numbers registered in the phone book and how many exactly?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started