Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with Conceptual Model for next assignment: Richmond Alternative Family Therapy (RAFT) is a small family counseling practice located in Richmond, Virginia. It needs

Need help with Conceptual Model for next assignment:

Richmond Alternative Family Therapy (RAFT) is a small family counseling practice located in Richmond, Virginia. It needs an information system to schedule appointments. There are currently five counselors working in the practice. Their facility has four rooms that can be used for scheduling counseling sessions. Each appointment is scheduled for a particular date and has a start time and a duration (in minutes). Each appointment is for exactly one counselor and exactly one client. Each counselor may have many appointments and each client can have many appointments. Each appointment is in a particular room and each room can have many appointments. However, no room can have more than one appointment being held at any particular time. Of course, when a new counselor, client, or room is added to the system, it will not have had any appointments, so it is possible for each to exist without being associated with a particular appointment.

Counselors and clients are both people, so they will need standard contact information: first name, last name, address, city, state, zip code, phone number, email address. Rooms have a room number and a room name.

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_2

Step: 3

blur-text-image_3

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 M Kroenke, David J Auer

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions

Question

1 . Television News channels importantance of our Life pattern ?

Answered: 1 week ago