Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Write an SQL statement to display each shipping date for customer 1005 from the orders table. Display both the customer number and the shipping date.
How can a DBA use the profile concept in Oracle to implement password policies? Why? Please provide specifics using your own words and cite your source(s).
Question regarding a basic Oracle PL/SQL statement. in the following case statement I need to replace the +14, + 7, +3 with the values that are pulled from a table called checkout_periods with materia
From an Oracle database security standpoint what are the pros and cons for using Database Configuration Assistant (DCBA) to create a database versus manually creating a database? Why? Please provide s
This assignment aims at enhancing your skills of using complex SQL statements to solve more realistic business problems. Work through each section in the SQL queries and subqueries tutorial, pay speci
Provide an example of an Oracle trigger or a SQL Server trigger; explain what the purpose of the trigger and how it may contribute to the database security. Remember to explain using your own words an
Why do you think that it would be important to have the flexibility of using a variety of languages in the development of database systems?
You choose the appropriate data type and field size for each column and enter 2 department records and about 5 employee records.Then, use phpMyAdmin to run this SQL statement: select * from department
Basic Concepts of PL/SQLThis assignment is due for online students by midnight Sunday of Week 5 and for on-ground students before the Week 5 class. On-ground students will share their projects with th
Given the assumption that a VENDOR can supply many products and a PRODUCT can be supplied by many vendors, an ERD would look like
A video can be rented many times over its lifetime; therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. How do I write
Assignment 2: Final Project-Core Components of PL/SQL This assignment is due for online students by midnight Sunday of Week 11 and for on-ground students before the Week 11 class. On-ground students w
Write an SQL statement to display the SKU and SKU_Description for products having QuantityOnHand equal to 0.
Relational or SQL databases are core to most operational business functions. You have read about tables, records, relationships, etc., in this weeks reading. Let's discuss how relational databases wor
Consider the following GRADEBOOKrelational schema describing the data for a grade book of a particular instructor. (Note: The attributes A,B,C, and DofCOURSESstore grade cutoffs.)
Write a sub-query that returns employees who did not place orders on or after May 1st, 1998. Include the employeeid, last and first names.
Create a VIEW that returns the total number of daily orders placed in July 1996. Display the Number of Orders and the order date.
Further suppose that the key of EMPLOYEE is EmployeeID and the columns of PHONE_NUMBER are PhoneNumberID (a surrogate key), AreaCode, LocalNumber, and EmployeeID (a foreign key to EMPLOYEE).
The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Orac
Write a query to display the total number of employees and the total number of employees hired in 1980, 1981, 1982, 1983. If the employees are hired in the year not mentioned above, have a separate co
Create a referential integrity constraint on OwnerID in PET. Assume that deletions should not cascade. The PET_OWNER and PET tables already exist, so create the constraint only
What are some of the best practices for Disaster recovery?What are some of the best practices for securing SQL Servers?
PET_2(PetName, PetType, PetBreed, PetDOB, OwnerID)- PetName should be underlined(to indicate Primary Key) and OwnerID should be italics (for foreign key).
Write a SELECT statement that returns four columns: VendorName, InvoiceNumber, InvoiceDate, and InvoiceTotal. Return one row per vendor, representing the vendor's invoice with the earliest date.