Completed

SQL Relationships

SQL Relationships

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”, “CUNY SPS BSIS program could track per cent of students working in the field that have taken this course”, etc.

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

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.

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.

Skills: SQL

See more: sql relationships w3schools, sql server relationships, many to many relationship in sql server examples, many to many relationship sql query create table, mysql relationships between tables, many to many relationship sql query, how to create relationship between two tables in sql, sql query to find one to many relationship in same table, sql money add field, edit field order clicking arrows using php mysql, sql search phrase field, show field selecting radio button using javascript, students semester projects using jsp servlets, sql server xml field insert xml file, sql insert file field, sql statement deleting field, sql remove part field, sybase sql anywhere encrypt field, sql insert xml field, sql relationships map

About the Employer:
( 0 reviews ) Brooklyn, United States

Project ID: #24285656

Awarded to:

nicrosoft

Hi there, I'm a professional database developer having competitive expertise and experience in database development and database management, MS Excel, MSSQL, Oracle DB , My SQL, Postgreg, MS Access, Data Analysis, UML More

$30 USD in 2 days
(12 Reviews)
3.8

5 freelancers are bidding on average $29 for this job

chernousovv01

Hi, How are you? I read your project post and very interested in your project. I can build above requirement query in a time. I'm ready to start work from now. So if you have mind to work with me, let's discuss via ch More

$20 USD in 1 day
(0 Reviews)
0.0
CodingHelpLine

Hello With Database design, RDBMS, No-SQL, SQL Programming, TSQL, PL/SQL, Packages, Stored Procedures, Functions and Query writing skills, I can provide excellent help in completion of your database project. I have g More

$30 USD in 2 days
(0 Reviews)
0.0
frysfr

Hi, I’m a senior Database Administrator and developer, with 4y+ of experiences. I just started using the Freelancer. I’ve designed and developed a various databases throughout my career. This should be quite a sim More

$16 USD in 2 days
(0 Reviews)
0.0
BaigTalha

I read Your requirement i can made you such type of script of student and course table in student table there is no repetive student and in course table there is no repetive coourse i can creat such a table in which on More

$50 USD in 2 days
(0 Reviews)
0.0