Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Conduct research to find relevant information using reliable sources to support your views. (Use at least 2 academic books and 3 scholarly articles from a library database
Create a SQL Server database called: ITCO333Database. Using Data Definition Language (DDL) and Data Manipulation Language (DML) you will create tables based on your Unit 1 ERD. In addition, you will c
Write INSERT statements to add the data shown in Figure 2-30 to the PROJECT table.Run these statements to populate the PROJECT table. (Hint: Write and test an SQL script, and then run the script.
Procedure, The company wants to offer an incentive of free shipping to those customers who have not returned for two months. Create a procedure named PROMO_SHIP_SP that determines who these customers
Write an UPDATE statement to change the phone number of employee with EmployeeNumber 11 to 360-287-8810. Run this SQL statement.
Write SQL statements that will retrieve the following data from a database, using Subqueries and Joins. Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the f
Write a procedure which take SSN and final score which will change the final score of the student, write the old and new scores.
Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.
Write down a query to exhibit the ENAME, COMM, SAL, HIREDATE, NEW_SAL. The NEW_SAL will be computed by the following rule:
List all the names of people who work for the company Wipro all along with the cities they live in.
Write down an SQL DDL definition of this database.
Sketch the diagram of logical structure of oracle database and describe it in brief. Discuss and critically illustrate out the objectives of Query Processing.
The ADO (ActiveX Data Object) data control is the primary interface between the Visual Basic application and the database. Illustrate out the following properties associated with ADO data control:
The following is a sample report from UTM Restaurant demonstrating normalised data. You’re required to show the First, Second and Third Normal Forms of following:
List and briefly illustrate out five (5) potential benefits of database approach compared to conventional file systems.
Demonstrate a equi Join operation. How is a trigger different from procedure?
What does SQL signify? Describe it in detail with its subcategories. What SQL statement is employed to delete the table ‘Student’?
What is Normalization and its need. Explain the Anomalies in 3NF relations? what is a stored procedure? why do we require them? How are they different from functions and triggers?
Distinguish between SQL and embedded SQL.What is Sequence? How it is created in PL-SQL?
Write down the syntax of Table Creation and Deletion commands. What do you understand by view? How it is created in PL SQL?
What is advantage of using indexes? Write the statements to create and delete an index? Write down the types of integrity constraints used in Transact-SQL.
Write fitting SQL for the following English queries.: Find the names of parts whose weight is between 10 and 15. Which supplier supplied what parts to the 'Sorter' job?
Write the syntax of ‘ORDER BY’ clause used in ‘SELECT’ statement. Distinguish between GRANT and REVOKE command.