Cônsider a database with the following tables: v Patient(PatientlD. PatientName, NumberOfVisits) v Doctor(DoctorlD. DoctorName) v Appointment(AppID, DoctorID, PatientID, Date, time) Write SQL statements or the necessary steps that do the following: a) Write the SQL statements required to create the above tables. You have to choose the best data type for each column, and all necessary keys (primary and foreign

Cônsider a database with the following tables: v Patient(PatientlD. PatientName, NumberOfVisits) v Doctor(DoctorlD. DoctorName) v Appointment(AppID, DoctorID, PatientID, Date, time) Write SQL statements or the necessary steps that do the following: a) Write the SQL statements required to create the above tables. You have to choose the best data type for each column, and all necessary keys (primary and foreign

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.3CP

See similar textbooks

Similar questions

For the following database scheme Employee(empNo.fName,IName,address,DOB,sex,position,deptNo) Department(deptNo.deptName,.mgrEmpNo) Project(projNo.projName,deptNo) WorksOn(empNo.projNo.dateWorked.hoursWorked) Write an SQL statement to produce a list of the total hours worked by each employee arranged in order of employee number I
Database: CUSTOMER (CustomerID, LastName, FIrstName, Phone, EmailAddress) PURCHASE (InvoiceNumber, InvoiceDate, PreTaxAmount, CustomerID) PURCHASE_ITEM (InvoiceNumber, InvoiceLineNumber, Item Number, RetailPrice) ITEM (ItemNumber, ItemDesciption, Cost, ArtistLastName, ArtistFirstName) Write an SQL statement to show which cutomers bought which items, and include any items that have not been sold. Include CUSTOMER.LastName, CUSTOMER.FirstName, IvoiceNumber, InvoiceDate, ItemNumber, ItemDescription, ArtistLastName, and ArtistFirstName,. Use a join using JOIN ON syntax, and sort the results by ArtistLastName and ArtistFirstName in ascending order. Note that in Microsoft Access this require multiple queries. From Database Concepts 9th Ed. (Kroenke)
Computer Science This question is related to pl/SQL:- Using a Cursor in a Package In this assignment, you work with the sales tax computation because the Brewbean's lead programmer expects the rates and states applying the tax to undergo some changes. The tax rates are currently stored in packaged variables but need to be more dynamic to handle the expected changes. The lead programmer has asked you to develop a package that holds the tax rates by state in a packaged cursor. The BB TAX table is updated as needed to reflect which states are applying sales tax and at what rates. This package should contain a function that can receive a two-character state abbreviation (the shopper's state) as an argument, and it must be able to find a match in the cursor and return the correct tax rate. Use an anonymous block to test the function with the state value NC.
Exercise 3: Procedural SQLWrite the following PSM functions or proceduresa) Take a price as argument and return the model number of the PC whose price isclosest.b) Take a maker and model as arguments, and return the price of whatever type ofproduct that model is.
For the following database scheme Employee(empNo,fName.IName.address.DOB.sex,position.deptNo) Department(deptNo.deptName,mgrEmpNo) Project(projNo.projName,deptNo) WorksOn(empNo.projNo.dateWorked,hoursWorked) Write an SQL statement to find all the details of employees who are female
Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.
Write SQL queries for the following statements. 1) Write a stored procedure which takes an integer value as argument from user and displays its table up to 10 in given For example: if user send 7 as an argument then, 7 x 1 = 7 7 x 2 = 14 …… 7 x 10 = 70. 2) Write a stored procedure which takes two arguments from user, display table of first argument from 1 to value of second
PATHS is a table that contains information about paths on a number line. The structure of PATHS is as follows, where x1 and x2 represent that there is a path from Coordinate x1 to Coordinate x2 (You can't move from Coordinate x2 to Coordinate x1 ). NAME ΤΥΡE NULLABLE X1 INT FALSE X2 INT FALSE Problem Please write an SQL statement that returns the beginning and end point of each path in PATHS . Sort them by the value of the beginning point in ascending order. Constraints • In the case where a direct path from Coordinate a to Coordinate b is available, no path from Coordinate b to Coordinate a will be given. |x1-x2| = 1 • No path will overlap with one another. Example Suppose that PATHS is as follows: x1 x2 1 2 2 3 4 7 7 6 This table can be visualized as follows: START END END START 7 8. 9 Therefore, your SQL statement must return the following: start end 1 4 8 6
relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: Read a Book id provided by user at run time and store it in a variable. Fetch the Author and title of the book having the entered id and store them inside two variables Display the fetched book author and title.
Write SQL queries for the following statements. 1) Write SQL code which declares two variables for name and address. Store your name and address in respective variables. Display name and address in a single line using print statement. 2) Display table of 10 in given format using 10 x 1 = 10 10 x 2 = 20 . . . 10 x 10 = 100. 3) Write a code which declares a variable and stores age of youngest employee from “Employee” table. And display name of youngest employee 5 times his. 4) Assume that in “Employee” table, Emp_id are assigned from 1 to onward. ie first employee’s eid is 1, second employee’s eid is 2 and so on. Write a code that displays name of eldest employee without using aggregate function of “max”. You can use count function
Develop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then finds student's first name, last name and phone, stores them in variables and prints them on the screen. 2. Similar to the above, only this time the program will receive student's first name only (instead of student's ID)Then program finds full name and address and prints it on the screen. For both programs please implement NO_DATA_FOUND and TOO_MANY_ROWS exceptions. (please refer to chapter 8 in PL/SQL by Example book)For number 2 program, display a message "Possibly you have two or more students with the first name ...." in TOO_MANY_ROWS exception block.
Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. declare vAddress employee.Address%vRoWTYPE; ( . . . . . . . . . . . . . . . . . . )begin select ename , address into vAddress from employee where salary = 1500; ( . . . . . . . . . . . . . . . . . . . ) DBMS_OUTPUT.PUT_LINE('NOM = ' || vEname || 'Adresse= ' || vAddress );exception when MANYROWS then ( . . . . . . . . . . . . . . . . . . . ) dbms_output.put_line(“This query returned many rows”); end;