Đã Đóng

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.

Kỹ năng: Microsoft SQL Server, MySQL

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) Israel

Mã Dự Án: #13802180

42 freelancer đang chào giá trung bình $477 cho công việc này

seekdeveloper

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 Thêm

$1030 USD trong 10 ngày
(29 Đánh Giá)
7.3
sphinxsolution

(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 Thêm

$1500 USD trong 30 ngày
(5 Đánh Giá)
6.2
prashushinde9

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 Thêm

$773 USD trong 750 ngày
(12 Đánh Giá)
6.1
m7slabs

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 trong 10 ngày
(41 Đánh Giá)
4.9
Shopify

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 Thêm

$721 USD trong 10 ngày
(6 Đánh Giá)
4.9
it2051229

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 trong 1 ngày
(56 Đánh Giá)
4.9
superwanchiu

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 Thêm

$500 USD trong 10 ngày
(16 Đánh Giá)
4.6
$555 USD trong 10 ngày
(28 Đánh Giá)
5.3
AliSafder

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 Thêm

$250 USD trong 10 ngày
(16 Đánh Giá)
4.3
a4logic

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 Thêm

$333 USD trong 3 ngày
(10 Đánh Giá)
4.5
$333 USD trong 10 ngày
(10 Đánh Giá)
3.9
fanninson45

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 Thêm

$250 USD trong 10 ngày
(5 Đánh Giá)
3.3
janmsidh

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 Thêm

$251 USD trong 5 ngày
(5 Đánh Giá)
3.1
mpapaleo

I'm a database expert. I'm available right now to start the project. Please to contact me with [url removed, login to view] chat to give me more information on your project. I'm a senior developer and system architect. I've 19 years Thêm

$250 USD trong 3 ngày
(3 Đánh Giá)
3.0
enterpriseit1

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 Thêm

$500 USD trong 10 ngày
(4 Đánh Giá)
2.6
muk07

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 Thêm

$250 USD trong 5 ngày
(4 Đánh Giá)
3.0
frankoke16

I am a full time programmer. I just wanted to have another job to gain more skills, learn from others and help others to solve their problems. In my full time job, i use .Net framework integrated with SQL, SSRS, MySql, Thêm

$350 USD trong 5 ngày
(6 Đánh Giá)
2.7
CodesignVE

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 Thêm

$555 USD trong 10 ngày
(1 Đánh Giá)
2.2
rebetikas

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 Thêm

$311 USD trong 2 ngày
(1 Đánh Giá)
2.3
mdakteruzzaman

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 Thêm

$250 USD trong 3 ngày
(4 Đánh Giá)
3.6