The font-office staff schedules the appointments for the visitors. The front-office staff details are staff ID, name, designation, phone number and an email address. The front-office staff coordinate with various department to schedule meetings. There is a supervisor for front-office staff. The department details to be stored are departmentID, description, email address and phone number. The appointments details to be stored are appointmentID, type, date and time. There can be two types of appointments; individual or organization. The visitors request appointments. The visitor details are visitor name, national ID, name of the organization, date, time and purpose of visit. The meetings are scheduled by the department, recorded by the front-office staff and attended by the visitors. The meeting details are meeting ID, title, data, time and list of attendees. The meeting types are single or multiple.

The font-office staff schedules the appointments for the visitors. The front-office staff details are staff ID, name, designation, phone number and an email address. The front-office staff coordinate with various department to schedule meetings. There is a supervisor for front-office staff. The department details to be stored are departmentID, description, email address and phone number. The appointments details to be stored are appointmentID, type, date and time. There can be two types of appointments; individual or organization. The visitors request appointments. The visitor details are visitor name, national ID, name of the organization, date, time and purpose of visit. The meetings are scheduled by the department, recorded by the front-office staff and attended by the visitors. The meeting details are meeting ID, title, data, time and list of attendees. The meeting types are single or multiple.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

How does method overriding relate to inheritance in object-oriented programming?
Briefly, explain the advantages and disadvantages of Nested classes in Object-Oriented Programming (OOP).
Discuss the role of dynamic dispatch or late binding in method overriding and its impact on runtime behavior in object-oriented languages.
Explain the Interface Segregation Principle (ISP) and its significance in object-oriented design.
What is an Abstract Data Type (ADT) and how does it work? What are the benefits of ADTs, exactly? What are some of the ways that the notion of heredity makes problem solving easier?
Within the context of the Object-Oriented paradigm, what role does the inheritance relationship play, and what are its implications?
Is it possible to describe coupling and harmony in the context of object-oriented computer research and design?
Distinguish between a superclass and subclass in a generalisation/specialisation relationship.
i)describe the meaning of polymorphism in the concept of Object-Oriented Programming.
Explain the concept of inheritance and the interdependencies between objects.
Q.No.2. A) Describe how is-a and has-a inter-class relationships may be implemented in object-oriented programming, give code examples to support your answer. B) Explain the difference between the object-oriented design concepts of generalization and specialization and describe how these relate to the inheritance feature in object-oriented programming languages.
Define the lifespan and visibility of a name-to-object binding.