You are asked to design a database that could be used by a relationship counselling service...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are asked to design a database that could be used by a relationship counselling service to manage data on their clients, their staff, and their sessions. Client information includes data on individuals (adults and children) and the relationships between them. Session includes the time and room that a counselling session took place in or is going to take place in. Here is what the service offers: Our services include relationship counselling for individuals and couples, family counselling, counselling for children and young people, and divorce mediation. We can help you if you're single or in a relationship, straight or gay, young or old. Whatever your circumstances we're dedicated to helping you get the most out of your relationships, no matter how big or small the issue. 1. Data model Create a data model for the counselling service. You will probably work through several design iterations. You do not need to include early designs in your documentation. Use the approach and notation we learned in class. Fully document your design process in a manner you would use if you were a professional database administrator - you may lose marks for the inclusion of extraneous information and unclear designs. Note that you have not been given any attribute lists, nor have you been given a full list of entities. You should therefore feel free to include anything that you think will be useful, but check what data you will need to fulfil the queries that you are being asked to create in Part 3. 2. Implementation 2a. Write SQL statements to implement your design. 2b. Implement your design using a suitable technology. Input enough data into your tables (however much you decide although you will need a minimum of 30 adult women in the dataset for Part 4) so that you can fully test your design and the queries you will write for Part 3. 3. Queries Managers might ask for the following information. Write an SQL statement to answer each using your test data to demonstrate that they work. a. Which couple has been our client the longest? b. Of the people who have had more than three sessions with us, what is the average number of sessions they've had? (Three is the minimum that people get when they first attend the service, so everyone gets three - here we are interested in those who stayed longer.) c. Is workload spread about the counsellors evenly? Activate d. Can we see a time table for tomorrow? What clients are coming to see us, what rooms are they booked into and at what times? You are asked to design a database that could be used by a relationship counselling service to manage data on their clients, their staff, and their sessions. Client information includes data on individuals (adults and children) and the relationships between them. Session includes the time and room that a counselling session took place in or is going to take place in. Here is what the service offers: Our services include relationship counselling for individuals and couples, family counselling, counselling for children and young people, and divorce mediation. We can help you if you're single or in a relationship, straight or gay, young or old. Whatever your circumstances we're dedicated to helping you get the most out of your relationships, no matter how big or small the issue. 1. Data model Create a data model for the counselling service. You will probably work through several design iterations. You do not need to include early designs in your documentation. Use the approach and notation we learned in class. Fully document your design process in a manner you would use if you were a professional database administrator - you may lose marks for the inclusion of extraneous information and unclear designs. Note that you have not been given any attribute lists, nor have you been given a full list of entities. You should therefore feel free to include anything that you think will be useful, but check what data you will need to fulfil the queries that you are being asked to create in Part 3. 2. Implementation 2a. Write SQL statements to implement your design. 2b. Implement your design using a suitable technology. Input enough data into your tables (however much you decide although you will need a minimum of 30 adult women in the dataset for Part 4) so that you can fully test your design and the queries you will write for Part 3. 3. Queries Managers might ask for the following information. Write an SQL statement to answer each using your test data to demonstrate that they work. a. Which couple has been our client the longest? b. Of the people who have had more than three sessions with us, what is the average number of sessions they've had? (Three is the minimum that people get when they first attend the service, so everyone gets three - here we are interested in those who stayed longer.) c. Is workload spread about the counsellors evenly? Activate d. Can we see a time table for tomorrow? What clients are coming to see us, what rooms are they booked into and at what times?
Expert Answer:
Answer rating: 100% (QA)
Designing a database for a relationship counseling service involves identifying the entities their attributes and their relationships Below is a stepbystep approach to creating a data model for the co... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
60-kg person walks from the ground to the roof of a 74.8m tall building. How much gravitational potential energy does she have at the top of the building?
-
Discuss Networking technologies. Research Software Defined Networking (SDN). Write 300 + words explaining the technology.
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Find the indefinite integrals (a) sin 3x cos 5x (b) cos 7x cos 5x (c) sin 2 x (d) cos 2 x (e) cosh 2 x (f) sinh(5x + 1)
-
State the four quantum numbers, then explain the possible values they may have and what they actually represent?
-
Calculate the pH of a 1.0 M solution of methylamine (K b = 4.38 10 4 ).
-
If it is 4:00 now, what time was it 67 hours ago?
-
Clark Kent, Inc., buys crypton for $0.80 a gallon. At the end of processing in Dept. 1, crypton splits off into products A, B, and C. Product A is sold at the split-off point with no further...
-
V3.1) Certain "personal" independence rules (such as prohibitions on stock ownership in an audit client) apply to a professional's close family members. State why you believe this is so. V3.2) All ...
-
The relief time provided by a standard dose of a popular children's allergy medicine averages six hours with a standard deviation of two hours. a. Determine the percentage of children who experience...
-
Suppose a country's productivity last year was 84. If this country's productivity growth rate of 5 percent is to be maintained, this means that this year's productivity will have to be: A. 88.2. B....
-
What is meant by "loose coupling" and "strong internal cohesion" of subsystems? Why are these desirable goals to achieve in the factoring process?
-
Sabotage often targets equipment, operations, and . a. people b. files c. systems d. work products
-
Define the concept of a control.
-
Why must auditors focus on controls as a system?
-
Studies have found that managers spend about percent of their time resolving workplace conflicts. a. 2 b. 9 c. 13 d. 25
-
Kaiser Industries has bonds on the market making annual payments, with 1 8 years to maturity, a par value of $ 1 , 0 0 0 , and a current price of $ 1 , 0 7 7 . 9 5 . At this price, the bonds yield 7...
-
(a) Find the equation of the tangent line to f(x) = x 3 at the point where x = 2. (b) Graph the tangent line and the function on the same axes. If the tangent line is used to estimate values of the...
-
Are associative entities also weak entities? Why or why not? If yes, is there anything special about their "weakness"?
-
Visit www.kimballgroup.comand locate Kimball University Design Tip 37. Study this design tip and draw the dimensional model for the recommended design for a "pipeline" application for university...
-
Add minimum and maximum cardinality notation to each of the following figures, as appropriate: a. Figure 2-5 b. Figure 2-10a c. Figure 2-llb d. Figure 2-12 (all parts) e. Figure 2-13c f. Figure 2-14
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Perform a horizontal analysis of the balance sheets and income statements...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Perform a vertical analysis of the balance sheets and income statements for...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Calculate earnings per share, the price-eam- m'ssm jngS ratio, the gross...
Study smarter with the SolutionInn App