Lengkap

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:

Kemahiran: Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data, Microsoft Access, Oracle, SQL

Lihat lagi: 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

Tentang Majikan:
( 40 ulasan ) dubai, United Arab Emirates

ID Projek: #19338170

Dianugerahkan kepada:

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 dalam sehari
(1 Ulasan)
0.0

17 pekerja bebas membida secara purata $40 untuk pekerjaan ini

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 dalam sehari
(174 Ulasan)
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 dalam 0 hari
(9 Ulasan)
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 dalam 0 hari
(23 Ulasan)
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 Lagi

$10 USD dalam sehari
(3 Ulasan)
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 Lagi

$25 USD dalam sehari
(1 Ulasan)
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/ Lagi

$100 USD dalam sehari
(0 Ulasan)
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 Lagi

$25 USD dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
$25 USD dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 Lagi

$25 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$25 USD dalam sehari
(0 Ulasan)
0.0
anuchetty19

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

$25 USD dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0