Suoritettu

Database Management Systems

Using SQL to (i) create and manipulate database tables, and (ii) extract information from a database.

1. List the complete Tasks table. [11 points]

Answer:

2. List the number and name of all clients that are represented by consultant 22 or that have credit limits of $10,000. [11 points]

Answer:

3. For each work order, list the order number, order date, number of the client that placed the order, and name of the client that placed the order. [11 points]

Answer:

4. List the number and name of all clients represented by Sarah Allen. [11 points]

Answer:

5. List the name and remaining credit (CreditLimitBalance) for each client. [11 points]

Answer:

6. (Optional) For each consultant, list the consultant last name, the average balance of the consultant’s clients, and the number of clients assigned to the consultant. Order the records by consultant name. [10 points]

Answer:

7. Create a new table named Sept21 to contain the columns OrderNum, TaskID, Description, ScheduledDate, QuotedPrice for all rows on which the ScheduledDate is 9/21/2018. You have to select the required information from the relative tables, then use an SQL command to put the result in a newly-created table. [11 points]

Answer:

8. In the Sept21 table, change the description of TaskID PI54 to “Misc. Printing.” [11 points]

Answer:

9. (Subquery) Find the number of hardware-based orders in OrderLine. In other words, how many “Hardware major” and “Hardware minor” orders have been placed in OrderLine? [11 points]

Answer:

10. Use CREATE TABLE to create a new table, called RITStudents, that has 3 attributes, as follows: UID (integer number), Name (text), and Joined (date). [12 points]

Answer:

Taidot: Tietokannan hallinto, Tietokantaohjelmointi, Microsoft Access, Oracle, SQL

Näytä lisää: top ranked companies using customer relationship management systems, database management project using excel, library database management system using access, database management system notes, database management system tutorial, relational database management system, advantages of database management system, types of database management system, database management system examples, database management system software, database management system database software, cricket score board management systems using oracle, programming stock management software using sql server database, ebay database management systems, database management systems projects air ticketing, database management system project using ajax, database management system using netbeans, database management using ajax, hospital database management system using sql, source code hospital management system using sql database

Tietoa työnantajasta:
( 40 arvostelua ) dubai, United Arab Emirates

Projektin tunnus: #19338170

Myönnetty käyttäjälle:

newmindstech

I just finished similar kind of job here on Access database, let me know if you are interested in going ahead with this. Can do tonight. the price is fair as FL takes commission! Sorry mate! thanks Jag

$15 USD 1 päivässä
(1 arvostelu)
0.0

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

truongnguyen86

Hello there, i'm expert on writing complex queries, let me help you with this. I think i can finish it in a couple of hours. Waiting for your response if interested. Thank you!!

$50 USD 1 päivässä
(174 arvostelua)
6.8
WilliamArispe

If you send me the right file, will be my pleasure aswers all questions about. Please contact me and send me the BITS Database.accdb. You attached the lock file (.laccdb) not database file(.accdb).

$30 USD 0 päivässä
(9 arvostelua)
5.0
usman1493

Hey A Data base design and database development expert is here I can help you with your database design and SQL Queries Task This is an initial bid Feel free to message us Regards

$25 USD 0 päivässä
(23 arvostelua)
4.7
fastlabindia

Greeting!. Yours work is one of the tasks that can be done very perfectly by us. We work within your budget, Within your deadline. We are highly experienced Post Graduate Engineers, IT, ITES, Software, Infrastructure P Lisää

$10 USD 1 päivässä
(3 arvostelua)
1.9
sagom

Software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft technolo Lisää

$25 USD 1 päivässä
(1 arvostelu)
1.1
cristianR909090

Hi I can help you to do your interesting work. And here is my skill: ◆Web Development: Websites Back and Frontend◆ .NET Framework 2.0/3.0/3.5/4.0/4.5 ASP.NET Webform/MVC/WPF/WCF IIS 6.0/7.0/8.0, Windows2008/ Lisää

$100 USD 1 päivässä
(0 arvostelua)
0.0
bishwajitpaul

Hello Sir Hows you doing ? I am a new freelancer looking for my first job here on freelancer . I have worked on similar projects on Up-work.I am a entry level DBA who have decent command over Oracle ,MySQL ,datab Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
Sanjaykumar557

Dear Employer, I will provide you the best and satisfactory result by using my Experience and skill set. We can discuss more on your requirement via chat and can start. Thanks.

$25 USD 1 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
pedroim

I have experience in systems development, database as well as Office package. I am willing to take the requested task.

$133 USD 1 päivässä
(0 arvostelua)
0.0
junsionzhang

as a database expert for 10 years , I think your projects is simple. all the sql is used again and again in my daily life and many project , I can do it now and finish it as soon as possible.

$35 USD 1 päivässä
(0 arvostelua)
0.0
b0b90

Hi i am a professional sql developer and i can help you build this assignment very quickly lets discuss it over chat

$50 USD 1 päivässä
(0 arvostelua)
0.0
SkyBluePhil

Using my SQL database skills I am confident that I can complete this job successfully. I have 6 years experience. You have set out in great detail what needs to be done which is very helpful. I see there is a BITS data Lisää

$25 USD 2 päivässä
(0 arvostelua)
0.0
databasedba

Dear Hiring Manager, I am an Oracle Certified Database Professional (OCP). I have complete masters in computer science. I am a database professional with 15 years’ experience. After carefully reviewing the experience Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
anuchetty19

Have exp in handling databases like sql server,oracle 11g Relevant Skills and Experience Project developr

$25 USD 1 päivässä
(0 arvostelua)
0.0
eadames9

Hello, I am a specialist in database process development, I can help you with your requirements, write me to enter details and give you a solution.

$25 USD 1 päivässä
(0 arvostelua)
0.0