Answered: database fundementals: GIVEN:…

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

Related questions

Concept explainers

Question

database fundementals:

GIVEN:

Participant (PNumber, LastName, FirstName, Address, City, State, PostalCode, PhoneNumber, DOB)

SK-->FirstName

AK-->PhoneNumber

Class(ClassNum, Description, NumOfPerson, Fee)

SK-->Description

ClassParticipant(PNumber, ClassNum, DataOfClass)

FK-->PNumber-->Participant

FK-->ClassNum-->Class

Expand the database design so it will support the following report: Colonial Adventure Tours needs to send an invoice to each participant, listing the classes in which the participant is enrolled as well as the total fees for the classes. The invoice should include the participant’s full name and address.

Answer in both DBDL and E-R diagram

Expert Solution

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions