Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke

4th Edition

0136086535, 9780136086536

More Books

Students also viewed these Databases questions