Create a single trigger for recording the requested

Assignment Help Database Management System
Reference no: EM133592797

Question 1. Calculating Days Between Ordering and Shipping An analyst in the quality assurance office reviews the time elapsed between receiving an order and shipping the order. Any orders that haven't been shipped within a day of the order being placed are investigated. Create a function named ORD_SHIP_SF that calculates the number of days between the basket's creation date and the shipping date. The function should return a character string that states OK if the order was shipped within a day or CHECK if it wasn't. If the order hasn't shipped, return the string Not shipped. The IDSTAGE column of the BB_BASKETSTATUS table indicates a shipped item with the value 5, and the DTSTAGE column is the shipping date. The DTORDERED column of the BB_BASKET table is the order date. Review data in the BB_BASKETSTATUS table, and create an anonymous block to test all three outcomes the function should handle.

Question 2. Tracking Pledge Payment Activity The DoGood Donor organization wants to track all pledge payment activity. Each time a pledge payment is added, changed, or removed, the following information should be captured in a separate table: username (logon), current date, action taken (INSERT, UPDATE, orDELETE), and the idpay value for the payment record. Create a table named DD_PAYTRACK to hold this information. Include a primary key column to be populated by a sequence, and create a new sequence named DD_PTRACK_SEQ for the primary key column. Create a single trigger for recording the requested information to track pledge payment activity, and test the trigger.

Question 3. Use Mongo shell 4.2 database commands to answer following questions in restarurants.json from MongoDB Lab Exercise (Week 12):
a. List id and address of borough: Manhattan, cuisine: American and name westside restaurant.
b. List address and Grades for street Broadway borough Manhattan cousine American and Name Toast.

Reference no: EM133592797

Questions Cloud

What types of conditions might lead to hypercapnia : What types of conditions might lead to hypercapnia? How does this condition signal the body to alter the respiration pattern? You will want to describe
What are some effective strategies : What might happen to student learning if you fail to identify students' strengths or recruit interest? What are some effective strategies
What does km mean and what is the meaning of kcat : What does KM mean? What is the meaning of kcat? What is the meaning of kcat/KM? What is the upper limit of kcat/KM? What is an activity unit?
Crime-related concepts psychopathy-antisocial personality : Crime-related concepts like psychopathy, antisocial personality, and criminal lifestyle can be thought of as existing on a spectrum. explain
Create a single trigger for recording the requested : SHORT STORY - Create a single trigger for recording the requested information to track pledge payment activity, and test the trigger
Write a reflective homework discuss and evaluate development : In this homework, you will write a reflective homework discussing and evaluating your development as a writer over the course of this class.
Which learning disorder autism spectrum disorder : Children who struggle with word reading skills but have decent language comprehension skills likely have which learning disorder autism spectrum disorder
Result of the person learning history : On the other hand, Conditioned Motivating Operations (CMOs) are value- and behavior-altering events that are a result of the person's learning history.
Identify one ethical challenge that affects your client : Identify 1 ethical challenge that affects your client. Examine the role you will have as an advocate. Discuss how advocacy can be used for this situation.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd