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!
1. Develop a flowchart using the decision structure to solve the following problem.
A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches. One comes with a sandwich, cookies, and chips. The other comes with a sandwich, carrot sticks and a piece of fruit. The second box lunch is 1 ½ times as much as the first.
A program accepts the following data from a customer: name, address, phone number and how many of each type of box lunch they desire. They also indicate whether this is a government office (G), a corporate office (C), or a private party (P). Government offices receive a 10% discount on all orders. Private parties receive a 10% discount for orders totaling more than 50 box lunches. The output of the program prints the customer information, the order detail, and a total amount due upon delivery.
Rework Problem 1 above using a CaseOf instruction.
describe all the tables you have created. ?get table_name, status, num_rows, user_stats in user_tables system view ?get table_name, constraint_name, constraint_type in user_constr
What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge
Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b
Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in
Views in relational algebra: 1. Basic expression contains either a) A relation in the database. b) A constant relation. 2. General expressions are madde out of sma
What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys
Question: (a) What are decision support systems, and what role do they play in the business environment? (b) Data mining is a knowledge discovery process of automated extr
Problem 1. Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 Writing a PL/SQL program to Insert data
Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela
A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd