Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Question 1 .Describe a specific scenario, situation, or application where using a foreign key would be necessary.
Question 2. Explain your reasons, including the characteristics of the data, that necessitate the foreign key.
Question 3. Explain an application requirement that would necessitate the use of a view.
Question 4. Suggest three DDL and three DML commands that you believe are most important, and provide an example of their use.
Question 5. Explain what each DDL and DML command does for each SQL statement that you have suggested.
I'm not really sure how to answer these questions. There are five questions.
Create a trigger named Products_INSERT that inserts the current date for the DateAdded column of the Products table if the value for that column is null. Test this trigger with an appropriate INSERT statement.
Create a table called TransactionLog. Create a trigger, which inserts a new record (user CardNo, ISBN, date) into the TransactionLog table whenever the a borrower checks out a book or returns a book.
Write down SQL needed to create employee table containing the following data: employeeID, text, length of 5, primary key lastName, text, length of 25
Write a script that creates and calls a function named fnItemTotal that calculates the total amount of an item in the OrderItems table (discount price multiplied by quantity)
Get the movie title for all movies that are comedy or horror, rename the output attribute name to be "Happily Scared"
Give me a list of all the proposed prices for the next year from the l_foods table. Sort your results by proposed_price. (Note that proposed price, is price + price_increase.)
Explain the security mechanisms available for a database and how the data will be protected.
consider the relational schema of part of a firm database below. write a sql query for each of the following
Prior to the adoption of SQL as a standard by the American National Standards Institute (ANSI), each database management system (DBMS) had its own unique command language and syntax. SQL was adopted as an ANSI standard in 1986. The International S..
Execute queries to confirm that the basket order status and product stock levels have been appropriately modified by the trigger.
List the employee_id and employee_name of the employees form the l_employees table with the top 4 credit limits.
question 1write a perl subroutine for temperature conversion named converttemp. it should be able to handle both
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd