Database Design

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.

Færdigheder: Microsoft SQL Server, MySQL

Se mere: design database project using mysql, update mysql database wordpress using javascript, design database using data ware hpusing, format create database website using mysql, detect mysql database crash using php, using php forms populate mysql database, mysql database project using jms java code, retrieve image mysql database display using visual basic, develop mysql database excelsheet using php, using google api search mysql database, database programming using jsf mysql pdf, design database using fifo method sql, retrieve data mysql database flash using actionscript, form design database, design database table product vendor, online sign design database, design database university managment, design database sql php, business partner design database, web design database photoshop, design database inventory chemicals, design database private taxi company, design database pedigrees, design database library system netbean, design database access

Om arbejdsgiveren:
( 0 bedømmelser ) Israel

Projekt-ID: #13802180

41 freelancers are bidding on average $480 for this job


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 Mere

$1030 USD in 10 dage
(29 bedømmelser)

(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 Mere

$1500 USD in 30 dage
(5 bedømmelser)

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 Mere

$773 USD in 750 dage
(12 bedømmelser)

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 Mere

$721 USD in 10 dage
(7 bedømmelser)

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.

$250 USD på 1 dag
(59 bedømmelser)

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 Mere

$500 USD in 10 dage
(21 bedømmelser)

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 Mere

$333 USD in 3 dage
(11 bedømmelser)

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

$500 USD in 10 dage
(41 bedømmelser)
$555 USD in 10 dage
(28 bedømmelser)

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 Mere

$250 USD in 10 dage
(16 bedømmelser)
$333 USD in 10 dage
(10 bedømmelser)

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 Mere

$250 USD in 10 dage
(5 bedømmelser)

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 Mere

$251 USD in 5 dage
(5 bedømmelser)

I'm a database expert. I'm available right now to start the project. Please to contact me with chat to give me more information on your project. I'm a senior developer and system architect. I've 19 years Mere

$250 USD in 3 dage
(3 bedømmelser)

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 Mere

$500 USD in 10 dage
(4 bedømmelser)

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 Mere

$250 USD in 5 dage
(4 bedømmelser)

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 Mere

$250 USD in 3 dage
(4 bedømmelser)

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 Mere

$450 USD in 4 dage
(2 bedømmelser)

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 Mere

$311 USD in 2 dage
(1 bedømmelse)

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 Mere

$555 USD in 10 dage
(1 bedømmelse)