The work has not been graded but I like the output that was submitted to me. Is it possible for the same prof to do the next assignment I will be submitting? If possible, I will greatly appreciate it.
Project
08/09/2022
Database (2) database design | Computer Science homework help
1-Write the relational algebra expressions for the following (using Ç):
branch (branch_name, branch city, assets)
customer (customer_name, customer street, customer city)
loan (loan number, branch_name, amount)
borrower (customer name, loan number)
account (account_number, branch name, balance)
depositor (customer_name, account number)
a) Find the names of all customers who have a loan and an account at bank.
b) Find all customers who have an account from at least the “Downtown” and the “Uptown” branches.
2- University schema
Classroom (building, room number, capacity)
Department (dept name, building, budget)
Course (course id, title, dept_name, credits)
Instructor (ID, name, dept_name, salary)
Section (course id, sec id, semester, year, building, room number, time slot id)
Teaches (ID, course id, sec id, semester, year)
Student (ID, name, dept_name, tot cred)
Takes (ID, course id, sec id, semester, year, grade)
Advisor (student ID, instructor ID)
Time slot (time slot id, day, start time, end time)
Prereq (course id, prereq id)
Write the following queries in SQL, using the university schema
a) Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result
b) Increase the salary of each instructor in the IT department by 15%.
c) Insert every student whose tot cred attribute is greater than 75 as an instructor in the same department, with a salary of $15,000.
3- Refer to the university schema used in Q.2 and write the following queries using Nested subqueries.
a) Find the average instructors’ salaries of those departments where the average salary is greater than $50,000. (Hint: use subqueries in the From Clause)
b) Delete all courses that have never been offered (that is, do not occur) in the section relation.
4- Deleting a record can be costly to an organization if not done in the right way. Let us assume you are working as a DBA (database administrator) and you used the delete command without specifying a condition in the where clause. What do you think will happen to the record in the database? And in case a record was deleted, is there a way to recover the lost data? Answer should be in your own words.
Customer #18989
Economics, 8 pages
Essay (any type)
08/09/2022
Outstanding work! This writer followed every instruction and my paper came back with an A! I recommend to anyone needing help! Thank you again
Customer #32178
Social Work and Human Services, 7 pages
Term paper
08/09/2022
My third using this writer and absolutely amazing work! Very punctual and very understanding
Customer #32651
Political science, 4 pages
Essay (any type)
08/09/2022
They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.
Customer #34672
Cultural and Ethnic Studies, 5 pages
Essay (any type)
08/09/2022
Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.
Customer #34671
Sociology, 7 pages
Essay (any type)
08/09/2022
The writer is very fast, professional and responded to the review request fast also. Thank you.
Customer #12351
Ethics, 7 pages
Essay (any type)
08/09/2022
I absolutely love this writer! He/she always cranks out a fabulous paper and follows the assignment guidelines/instructions perfectly. Thanks again for always providing such quality work!!!
Customer #24514
Anthropology, 5 pages
Essay (any type)
08/09/2022
Made 100% on both the outline and the paper. Quick turnaround time and my writer responded within 30 min or less. Any edits my instructor needed, my writer was patient and worked diligently to accomplish the task. Would recommend my writer to anyone!
Customer #25412
Management, 7 pages
Essay (any type)
08/09/2022
It took some time to achieve the product I was looking for, but we eventually got there. I do feel like a lot of hard work was put into this, and it even exceeded the page requirement. I'm pretty pleased overall. I give my thanks.
Customer #25412
Public Relations (PR), 6 pages
Response essay
08/09/2022
Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.
Customer #18756
Logistics, 5 pages
Research proposal
23/07/2022
I have been working with the writer all year and he has been a true blessing. Thank you.
Customer #11236
Sociology, 10 pages
Term paper
23/07/2022
Very well done! The writer took the time to produce a quality work.
Customer #12884
Finance, 8 pages
Ecology
23/07/2022
My third using this writer and absolutely amazing work! Very punctual and very understanding
Customer #13511
Ecology, 6 pages
Article review
23/07/2022
Excellent job as always received my assignment way ahead of my deadline. I really appreciate this writer.
Customer #23160
Geology (and other Earth Sciences), 7 pages
Dissertation/Dissertation chapter
23/07/2022
very satisfied with work!
Customer #31682
Statistics, 5 pages
Article
23/07/2022
thank you so much. .the paper was really good I am very happy with it and the writer followed my instructions very well.
Customer #12851
International Trade, 9 pages
Essay (any type)
23/07/2022
way above expectations. always a pleasure working with writer.
Customer #13423
International Trade, 8 pages
Blog post
23/07/2022
Custom writing is an excellent writing company. They always provide the best services. They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.
Customer #21058
Communications, 12 pages
Research paper
23/07/2022
I received the paper way ahead of time. Amazing!
Customer #21799
Health Care, 6 pages
Technology
23/07/2022
Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.
Customer #19152
Technology, 10 pages
Report (any type)/Brief report
23/07/2022
I had one typo but i can fix that myself. Thank you so much! It saved me a lot of time and it was finished earlier than expected!
Customer #14083
Nursing, 7 pages
Presentation/PPT
23/07/2022
Thank you very much for an excellent job - everything looks fantastic.
Customer #12077
IT, Web, 6 pages
Article
23/07/2022
Thank you so much! Awesome writing! You helped me a lot on this class and I appreciate you!
Customer #23710
Ecology, 5 pages
Journal article
23/07/2022
I absolutely love this writer! He/she always cranks out a fabulous paper and follows the assignment guidelines/instructions perfectly. Thanks again for always providing such quality work!!!
Customer #14153
Criminal Justice, 4 pages
Research paper
23/07/2022
OMG!!! Fantastic job, I truly appreciate this service. You all really make life a little easier, especially for full-time students that also work full-time and have kids at home. Thank You so much!!!
Customer #12309
Environmental studies and Forestry, 8 pages
Essay (any type)
23/08/2021
Writer did an excellent job on completing the discussion board assignment questions in a timely manner and the revising. I will be hiring this writer for future assignments.
customer #15268
Psychology, 4 pages
Essay (any type)
23/08/2021
You can completely rely on most of the writers of My Essay Nerd! They really provide a superior client experience, and the assignments are delivered on time.
customer #18320
Nursing, 6 pages
Dissertation
23/08/2021
Was very satisfied with my order. It was professionally done. Thank you very much.
customer #1315
Human Resource Management, 20 pages
Essay (any type)
23/08/2021
Very well written paper. Writer completed it before the deadline as well.
customer #1086
International Relations, 4 pages
Coursework
23/08/2021
Very prompt. Written as requested. Would use this writer again.
customer #15632
Economics, 2 pages
Annotated Bibliography
23/08/2021
Very impressed with the turnaround time and the attention to detail needed for the assignment.
customer #1780
Medicine, 3 pages
Discussion Essay
23/08/2021
Truly impressed with the quality of the work!
customer #1370
Sociology, 3 pages
Essay (any type)
23/08/2021
This writer was amazing. Great communication and followed instructions. Most importantly, the writing was well written and on time.
customer #1325
Human Resource Management, 10 pages
Journal Article
23/08/2021
This was the first time ever using this writer and it’s safe to say he did an amazing job on my essay and got an A! Will use her again for sure!
customer #1624
Business, 6 pages
Research proposal
23/08/2021
This is a great website. The chat group is available 24/7. To me, it's the most helpful thing. They are always there to assist and they're willing to help. Price-wise it's also fair. Most of the writers are highly professional and provide great quality work. Keep up the good work.,
customer #1369
Public Relations, 7 pages
Coursework
23/08/2021
The paper was detailed and exact to what I had instructed. Thank you!
customer #1253
Ethics, 4 pages
Discussion Essay
23/08/2021
Excellent communication skills, essay was written so beautifully and ahead of deadline. I would defo use this writer again.
customer #1682
Political Science, 8 pages
Report
23/08/2021
The orders that i have placed required the writer to employ SPSS, and answer questions. The writer has done a great job because I used their work to compare to work that was already completed. I have been very please and hope to continue the same writer for future help, because they make my work a lot easier.
customer #1680
Economics, 9 pages
Essay (any type)
23/08/2021
Thank you writer ID# 110762, I will definitely hire you again. I appreciate your service and time...awesome work.
customer #1585
Communication, 1 page
Annotated Bibliography
23/08/2021
I've used this site multiple times and I absolutely love them! The writer is my go to for amazing work and customer service is always there to help you find the best fit and price. I pay a little more for the writer but the work is well worth it.
customer #1736
Tourism, 4 pages
Essay (any type)
23/08/2021
If you are scanning reviews trying to find a great tutoring service, then scan no more. This service elite!
customer #1176
Management, 10 pages
Coursework
23/08/2021
I really love this website, excellent work so far. Will use in the near future.
customer #1620
Sociology, 5 pages
Research Proposal
23/08/2021
Great writer, will definitely be using again. I received a 98 on my paper for my MBA.
customer #1748
Business Studies, 12 pages
Literature Review
23/08/2021
Excellent paper is done in a quick and timely manner. The writer did an amazing job of including all of my topics and much more. Thank you!
customer #1271
Economics, 6 pages
Essay (any type)
23/08/2021
Excellent communication skills, essay was written so beautifully and ahead of deadline. I would defo use this writer again.
customer #1927
Psychology, 1 page
Journal Article
23/08/2021
Consistently excellent work, helps me get rid of stuck thoughts
customer #1356
Marketing, 5 pages
Essay (any type)
23/08/2021
Amazing!!! Really a wonderful job! Thank you so much!!!
customer #1268
Business, 8 pages
Essay (any type)
23/08/2021
Always does an awesome job!
customer #1924
Psychology, 4 pages
Report
23/08/2021
My Essay Nerd is a great platform to get your assignments completed. They have some awesome writers and they do exactly what is asked and more. I have had nothing but good experiences since I've used My Essay Nerd. Definitely recommend!!!!
customer #1567
Human Resource Management, 2 pages
Easy Testimonials
23/08/2021
I love your product! I would recommend this to anyone. What a great find!
Steve
Developer, Acme Co.
Easy Testimonials
23/08/2021
I receieved excellent customer support, and quickly. Thank you so much!
Linda Herman
Founder, Herman Studios
Easy Testimonials
23/08/2021
I needed a simple, easy-to-use way to add testimonials to my website and display them. Easy Testimonials Pro did all of that and more!
Janet Exampleton
Owner, Exampleton Productions