Category: MySQL

*** I WILL PROVIDE YOU ALL DOCUMENTS AND POWER POINTS FOR THIS ASSIGNMENT***
** SQL KNOWLEDGE IS REQUIRED**
For this assignment you need to create a self-join query. This is how you handle queries for U-Nary Relationships if you remember back to week 2 and ERDs.
You must perform this exercise twice:
1. Referee/Mentor (you will need to enter at least 10 rows of refs and mentors to run the query)
2. Nurse/supervisor self-join.
Here is an example to get you started that I went over in class:
What you need to submit:
1. Screen capture of both of your self-join queries showing the name of the nurse/ref and the name of the supervisor/mentor, with a second window logic check so that the reviewer can see that the ID numbers for each column matches correctly to the names.

!! I will provide you EERD,ERD and RS to build data !!
** You will be using SQL. **
Deliveries:
1. MDF and LDF files for database table build matching data dictionary.
2. database diagram in PDF or Word document.
3. Screen captures of your expanded navigation panel showing your CKs, DFs.
Include the following constraints:
1. Check Coach Assignment Role: VC, AC, HC.
2. Check State 2 letters for any table with a state column.
3. Default null phone to ”none provided” for any table with a phone.
4. Default state to ‘FL’ for any table with a state column.

!! I will provide you EERD,ERD and RS to build data !!
Deliveries:
1. MDF and LDF files for database table build matching data dictionary.
2. database diagram in PDF or Word document.
3. Screen captures of your expanded navigation panel showing your CKs, DFs.
Include the following constraints:
1. Check Coach Assignment Role: VC, AC, HC.
2. Check State 2 letters for any table with a state column.
3. Default null phone to ”none provided” for any table with a phone.
4. Default state to ‘FL’ for any table with a state column.

**** DUE TO OCTOBER 22 UNTIL 10 PM*****
!! I will provide you EERD,ERD and RS to build data !!
Deliveries:
1. MDF and LDF files for database table build matching data dictionary.
2. database diagram in PDF or Word document.
3. Screen captures of your expanded navigation panel showing your CKs, DFs.
Include the following constraints:
1. Check Coach Assignment Role: VC, AC, HC.
2. Check State 2 letters for any table with a state column.
3. Default null phone to ”none provided” for any table with a phone.
4. Default state to ‘FL’ for any table with a state column.

Need to RUN and NOT_RUN the sql queries given in the file attached below. Will send the database once you accept the assignment. Can tip as well if the assignment is done on time.

attached is the sql query for a file generation process from different tables , joining different tables from database.
please make a professional process flow diagram for the query and also in a word document , interpretate the query flow.

Hello working on Population the QuantigrationRMA database I will have the question and everything that need attach here

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.

For each question, submit your SQL code and a screenshot of the results. If the results are
too long, partial results are fine. Include relevant attributes for each result, to explain that
the result is correct. Do NOT include many unnecessary attributes. Do NOT use SELECT *.
1) List the articles (any type, not just articles) appearing in less than 2 coursepacks. List the article Number, Article Price, and the number of times they appear in a coursepack.
2) List the MBA students who are enrolled in any MSBA course. List the student’s name, gender, and GPA.
3) List courses starting in August (any day) with an average number of sections of 5 or more.
4) Find all case articles (format=”case”) required for DAT courses. Sort the results by the article title. List only the title, and article number.
5) List the students with a GPA less than 3.5 who are enrolled in 3 or fewer courses. List the
student’s name, major, and the number of enrolled courses. Order the results based on the
number of enrolled courses in decreasing order.
6) Find programs with more than 6 courses listed in the database. List the program name, total
number of sections, and earliest starting date of courses.
7) Find the average GPA of students that are required to take any courses in the BSBA program. List the course number, course name, and average GPA of enrolled students. List only the courses with an average GPA of more than 3.
8) For each student who is enrolled in more than 3 courses find the name, gender, and the number of enrolled courses. Order the result in increasing order of enrolled courses.
9) Find the pairs of articles (any type of article, means article, case, simulation,..) from the same
publishers with different formats. List the article number, Title, and publisher.
10) Find the courses enrolled by any student who has the letter “D” in their name. List the course name, section, and faculty name.
11) Find the courses taught by female faculties with more than 4 students enrolled. List the course number, faculty name, number of enrolled students, and program.
12) For the courses which have group assignment, list the course number, course name, title, article number, author, and assignment date. Only include coursepacks with assigned dates in September or October. Sort the results in ascending order of course name. Hint: You need to use Coursepacks.Group for the Group attribute.