SQL Relationships script

Use MySQL:

Submission should be a single SQL file, with comments, containing all the logic to fulfill the requirements. Please ensure the script can be executed multiple times without errors (ensure tables are deleted or recreated in the script so that the script can be executed multiple times).

SQL Relationships

1. Imagine that you are hired to create a basic database and a basic report for a school. In the SQL comments at the top of the script, write a short description of the school, and how the database is used by the school personnel. (some examples: “This database is used to register new students at Dog Obedience School”, “The Beauty Academy database determines how much revenue each class generates”, “Lucky Brake Driving School Database tracks accident rates across classes”, “BSIS program could track per cent of students working in the field that have taken this course”, etc.

2. You should create and populate tables - using SQL exclusively - for Courses and Students. Each table should contain at least four or five rows.

3. You are encouraged to add one or more new columns that would be of interest to the people who use the information in your database, as you have described in number one above.

4. Write a SQL Query that shows which students are taking which courses.

You need to create an additional table to fulfill the additional requirements listed below.

• One student should be able to register for more than one course; and

• One course should be able to be taken by more than one student.

• The student table should have not duplicate students. The course table should have no duplicate courses.

Habilidades: MySQL, SQL

Ver más: java chat program script sql, script dts sql server 2005, script profile sql users, script examples starting program, alibaba clone script sql, sample script bcp sql server 2005, write script sql schedule, free php script webshop sql, protect script sql injections, user registration script php sql, database country state city script sql, oracle script naar sql script, convert script windows program, sql program descompile exe, online banking system database script sql server, free star rating system script php sql, script gifting program, script sql 2005 backup, sql server development hourly rates, vb6 login script sql

Información del empleador:
( 20 comentarios ) New York, United States

Nº del proyecto: #13366071

9 freelancers están ofertando el promedio de $35 para este trabajo


Hello there, i'm expert on database designing also implementation, let me help you with this. Pls spend a little time to take a look at my profile because i've done many project like this before with MySQL. Waiting for Más

$100 USD en 2 días
(131 comentarios)
$61 USD en 0 días
(27 comentarios)
$15 USD en 1 día
(5 comentarios)

Hello, I have read your project description about Database Design and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have already desig Más

$50 USD en 1 día
(4 comentarios)

I am talented and experienced developer .I am a hard worker and enjoys working at all critical conditions. If hired by you I will be responsible to complete the task within the stipulated time frame and with utmost co Más

$15 USD en 1 día
(2 comentarios)

Hello, let's discuss in detail and I'm ready to proceed with this project . but need to know the correct budget of this project. have good day thanks

$15 USD en 1 día
(3 comentarios)

[login to view URL]~01b82f3b7fa81618af Good Day! i'm expert java dev with 8 years experience in IT area working with cutting edge technologies for both web application and software development. Más

$25 USD en 1 día
(2 comentarios)

hi, there, i wish to help your. i have great experience in oracle as well as mysql. i promise super work in 1 day. thank you.

$15 USD en 1 día
(0 comentarios)

hello sir i am experience of this job .i can do this very if you agree with me please reply and confirm me Thanks

$15 USD en 1 día
(0 comentarios)

Have got strong database skill. Given a chance will provide a single script file which will have all the requirements. Got involved in performance tuning projects by optimising complex queries. Looking forward to work Más

$15 USD en 1 día
(0 comentarios)