Question: c) Write FIVE (5) queries that demonstrates your knowledge and understanding of SQL. SQL statements to be used should include: Select, Update, Delete, From, Where,

c) Write FIVE (5) queries that demonstrates your knowledge and understanding of SQL. SQL statements to be used should include: Select, Update, Delete, From, Where, And, Count, Ascending, Order By. Ensure some of your queries use multiple commands. TWO (2) of the queries should join TWO (2) or more tables together. (20 marks) Task 3 Assessment and evaluation - 15 Marks Provide a written assessment and evaluation of the work you have undertaken. Your discussions should include:

How the database you have created meets the data and information requirements of your chosen organisation as identified in task 1a).

Why the use of ER modelling is an essential part in the design of a database solution, and how you used it to identify and rectify any design issues you encountered.

Any assumptions that you have made.

How the database supports the transactions that you identified in task 1a).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Sage Inc. experienced the following transactions for Year 1, its first year of operations: 1. Issued common stock for $50,000 cash. 2. Purchased $140,000 of merchandise on account. 3. Sold...

Part A: 1. Select an organization where you think the implementation of database is very essential. A minimum of 5 entities should be listed along with the data and information that would be stored...

Goals Explore triggers and stored procedures within a database, see how they work and how they are engaged. Create your own and see what happens. Instructions Use the same database as Lab 2 (see Lab...

What is SQL and why is it preferred for creating databases? What type of databases are created with SQL ( relational , networked, hierarchical, Object - Oriented databases - OOD ) ? Is SQL a single...

The Final Project allows you to demonstrate your knowledge and understanding of basic financial statements, financial ratio analysis, trend and common size analysis, market valuation of bonds and...

- - this statement will prevent messages of " ( 1 row ( s ) affected ) " SET NOCOUNT ON - - = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

Find the particular solution of the following ODE dv 2- + 3v = e dt v=1, t = 0 v = [a]e 3t/2 + [c]eld] %3D

Suppose a telephone company executive wishes to select a random sample of n = 20 out of 7000 customers for a survey of customer attitudes concerning service. If the customers are numbered for...

' o r ' - ' , a s appropriate. I f the l i m i t does not otherwise exist, enter DNE. lim x ( 3 6 x 3 + 3 x - 9 2 - 8 x + x 3 2 )

Oil and gas ventures operating as publicly traded partnerships typically attract sophisticated investors who purchase limited partnership interests. Investments in these types of publicly traded...

1. What have you learned about the potential market for soup in glass jars? 2. What else would you like to know? 3. How else would you assess peoples attitudes toward this concept? For several years,...

Refer to the American Association of Engineering Societies (AAES) survey of the publics knowledge of engineering, Exercise 9.7. Responses to the statement, Engineers are responsible for creating...

A system is represented by the state and output equations that follow. Without solving the state equation, find the poles of the system. X = -4 3. x+ -2 u(t) y = [5 1]x

13.1 Prepare a graph of the monthly forecasts and average forecasted demand for Industrial Air Corp., a manufacturer of a variety of large air conditioners for commercial applications. Months...

2. In this chapter, the reader should reflect on the following concepts: historical reason, goal orientation, core values and top performance.

1. To understand how to set goals in a communication process

11. How often have you passed on to others this type of information, which you have filled in yourself? Never, then you should think again.