You have been asked to design and implement a relational database to keep track of the following information for a yoga centre.
Each Yoga Student must be referred to by a Yoga Guru and must present a prescription for yoga therapy in order to receive treatments.
The center only treats yoga Patients who are at least 18 years old.
The center only employs Therapists who have at least 2 years of prior experience.
A Yoga Student may be referred to by different Ayurvedic Doctors at different times.
The database must store each prescription, both current and past.
Each prescription will list a diagnosis such as “sprained yoga” or “torn yoga”
A Yoga Student must make an Appointment for a specific date and time.
A Yoga Student can only make one Appointment for any given day.
When a Yoga Student visits the center at the appointed time he will be assigned a specific Physical Therapist.
A Yoga Student can be treated by different Yoga Guru Therapists on different days.
The system will record which Yoga Gurus treated the Yoga Student on a particular Visit to the center.
The system will also record what Treatment the Yoga Student received and what Equipment he used.
A Yoga Student can receive more than one type of Treatment and use more than one piece of Equipment at any given Visit.
Sample equipment “stationary bicycle” , “treadmill” , “weights”
Sample treatment: “heat” “ice” “electrical stimulation” “ultrasound” “massage”
Using MySQL Workbench draw an ERD to present your proposed design.
You must identify what attributes are likely to be stored for each entity based on prior knowledge or research.
Use SQL Server to implement your design, include PKs, FKs, and constraints.
Use SQL Server to populate the database with at least 5 records in each table
Write queries to answer the following questions:
How many yoga Patients has each Yoga Gurus seen in the past month?
Which piece of equipment has never been used?
List all information available for yoga Patients who have been at the center
List all information available for Therapists who work at the center
Which Yoga Gurus has seen the most yoga Patients
Which Yoga Student is the oldest Yoga Student in the clinic?
Which Yoga Gurus has the most job experience?
For each Therapist, list the Yoga Gurus name and the name of each Yoga Student he has treated.
For each Patient, list the Yoga Student name and the name of each piece of equipment he has used.
For each Patient, list the Yoga Student name and the name of each type of treatment he has received.
41 freelance font une offre moyenne de $480 pour ce travail
Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 8+ years of experience and I'm here for you! My Plus
(From the makers of Vivino & Dah Makan) Hi, I hope you are doing well, We are 7 year young rapidly growing Website & Mobile App Development Company based out of New Jersey, USA, Gold coast, Australia & Pune Plus
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Plus
Hi, I (Myself a senior PHP Developer) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the ve Plus
Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.
I just saw your description carefully. Your project is very easy for me. Although i am a new freelancer , I have accumulate full experiences on app developing. If you trust me , I can do it perfectly for you in a sh Plus
Dear Sir/Madam, Thank you for this wonderful opportunity. I am keenly considering your job post including these skills.I am working as team leader in A4Logic it is software and web solution company we are operati Plus
Hi There, I have been Through Your description, we have a specialized team for this particular task. You will not regret trying us. Many Thanks
I can work on it. Let me know when to start? I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.N Plus
SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p Plus
Hello Sir/Madam I have solid experience as Oracle, SQL Server, Sybase, Access DBA. I am SQL server certified DBA in both as DBA and Designer. I worked as DBA in USA for 13 years. I came back recently to start my own Plus
I'm a database expert. I'm available right now to start the project. Please to contact me with Freelancer.com chat to give me more information on your project. I'm a senior developer and system architect. I've 19 years Plus
Hi, I have read the description of your project. I have over 7 years of experience as a database developer. I have completed several similar projects. I can start this project right away. I have completed all past p Plus
Maybe i'm not the best, but no doubt good enough to make a project of this database. I've done a lot of database projects. Largest of them was automated management system for higher education institution. This database Plus
Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here Plus
Hello, i am a software engineer from Serbia with more than 8 years experience is writing windows desktop and web applications in international, distributed teams. I am also a certified Scrum developer. If you decide Plus
I'm a senior SQL developer, and this sounds like a simple school project. I'm able to start on this immediately. I'll develop the required script to produce the database you're after. I'll ensure commenting withi Plus
WARNING: Our bid is based on the average prices. Contact us to negotiate the price you want! We are an International company specialized in different areas. Our team is made by designers, developers, animators, mus Plus