Em Andamento

SQL Database

Project Description:

I have an SQL database of textbooks that I need help with. The database has the following tables:

textbook

course_to_textbook

course

department_to_course

department

university

I need help with queries that would allow me to do things like:

find out the top 10 most used biology books;

how many schools are using a certain book;

The top 10 books in use

The structure of this database looks like this:

One to Many Relationships

===============================

state_province ==> university ==> department

Each department is affiliated with a university.

Each university is affiliated with a state_province.

Many to Many Relationships

===============================

course <==> textbook

course <==> department

Each course has one or more textbooks while each textbook is in one or more courses.

Each course is taught at one or more departments while each department has one or more courses.

All the relationships are maintained by the id field of each entity.

For example, there are 381 different biology courses in the course table if you search title by '%biology%'. And then you can find thousands of biology books. For any of them, to find the number of universities that are using it, you need a query that's concerning 6 tables:

textbook

course_to_textbook

course

department_to_course

department

university

Which eventually lead to the university table. I need someone who can write such a query.

Skills required:

Data Processing, MySQL

Habilidades: MySQL

Ver mais: who can help you write a book, structure books, someone that help to write a book, need someone help me write a book, i would like to find someone to write a book, i need someone to help me write a book, how to find someone to write a book for you, how to find someone to write a book for me, how to find someone that can write a book for you, how do you find someone to help you write a book, how can i find someone to write a book for me, have someone help you to write a book, find someone to write a book for you, find someone to write a book, data structure in c books, data structure books, data structure book, books of data structure, books for data structure, book of data structure, book for data structure, book data structure, who can write a book for me, who can help me to write a book, need someone to help me write a book

Acerca do Empregador:
( 12 comentários ) Atlanta, United States

ID do Projeto: #5133588

Premiar a:

tretanz

Hired by the Employer

$5 USD / hora
(12 Avaliações)
3.9