• Find all staff fname and direct supervisor's fname. MariaDB [dreamhome]> select * from Staff1; | staffNo | FName | 1Name | position | sex | SA9 | Mary | Howe | Assistant IF | SG14 | SG37 | SG5 | David | Ford | Supervisor | M Ann | Beech | Assistant IF | Susan | Brand Manager IF | John White Manager IM | F | SL21 | SL41 | Julie | Lee | Assistant +- | staff supervisor I | Mary | Susan | David | Susan | Ann | Susan | Susan | John | Julie | John Output salary | branchNo | superno | | SG5 | SG5 | SG5 | SL21 | DOB | | 1970-02-19 | 9000.00 | | 1958-03-24 | 18000.00 | | 1960-11-10 | | 1940-06-03 | | 1945-10-01 | | 1965-06-13 | B007 B003 12000.00 | B003 24000.00 | B003 30000.00 | B005 9000.00 | B005 | NULL | SL21 1

• Find all staff fname and direct supervisor's fname. MariaDB [dreamhome]> select * from Staff1; | staffNo | FName | 1Name | position | sex | SA9 | Mary | Howe | Assistant IF | SG14 | SG37 | SG5 | David | Ford | Supervisor | M Ann | Beech | Assistant IF | Susan | Brand Manager IF | John White Manager IM | F | SL21 | SL41 | Julie | Lee | Assistant +- | staff supervisor I | Mary | Susan | David | Susan | Ann | Susan | Susan | John | Julie | John Output salary | branchNo | superno | | SG5 | SG5 | SG5 | SL21 | DOB | | 1970-02-19 | 9000.00 | | 1958-03-24 | 18000.00 | | 1960-11-10 | | 1940-06-03 | | 1945-10-01 | | 1965-06-13 | B007 B003 12000.00 | B003 24000.00 | B003 30000.00 | B005 9000.00 | B005 | NULL | SL21 1

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

• Write a simple stored function that Takes a gender as an input ● Find the staff whose gender matches the input Return the results Write a simple stored procedure that Takes a gender as an input Find the staff whose gender matches the input • Print the results
Customers CustomerID INT ◆ FirstName VARCHAR(50) ◆ LastName VARCHAR(50) H > Email VARCHAR(100) > Address TEXT Indexes F | Orders OrderID INT > CustomerID INT > OrderDate DATE ◆ TotalAmount DECIMAL (10,2) Indexes # ShippingInformation ShippingID INT > OrderID INT → ShippingAddress TEXT ShippingDate DATE -K > EstimatedArrivalDate DATE → ShipmentStatus VARCHAR(50) Indexes Reviews ReviewID INT > ProductID INT > CustomerID INT ◆ Rating INT Comment TEXT > DatePosted DATE Indexes OrderDetails OrderDetailID INT ▶I > OrderID INT HI-KO ProductID INT → Quantity INT Subtotal DECIMAL (10,2) Indexes T Categories CategoryID INT ◆ CategoryName VARCHAR(255) Indexes Products ProductID INT -H ProductName VARCHAR(255) > Description TEXT ◆ Price DECIMAL (10,2) -I+ CategoryID INT > DiscountID INT Indexes Discounts DiscountID INT ◆ Discount Code VARCHAR(50) ◆ Discount Percentage DECIMAL (5,2) > StartDate DATE > EndDate DATE Indexes For the design above, Write in SQL a query to print customer names who made…
11. List the isbn of the book, the id and firstname of the editors. Include all books in the bookeditor table.
DATABASE: library (library_name [pk], City, Phone, manager_SSN[pk, fk]) book (book_name [pk], Genre, Country) borrower (SSN[pk], Name, Birthyear, Fav book [fk], Gender) likes (SSN[pk, fk], book [pk, fk]) bookLoans (library [fk], books [fk]) manager (SSN[pk], Name, City, Address, Phone) Provide OPTIMIZED relational algebra for the following queries: 1 a) List name, gender, and age of all borrowers. b) List all male borrowers older than 65 years of age. c) List the book names loaned by at least one library and liked by at least one borrower. d) List the name and ssn of all borrowers who like their favorite book
herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraints
Child row is a related row where there is a ? Primary key Foreign key Candidate key Composite key
Branch(BranchNo, B_Street, B_Suburb, B_Postcode, Staff_No*, Start_Date, Monthly_Bonus, Telephone1, Telephone2, Telephone3, S_Name*) Staff(StaffNo, S_Name, S_Address, Position, Salary,Branch_No*, Supervisor_No) Property(PropNo, P_Street, P_Suburb, P_Postcode, Type, NoOfRooms, WeeklyRent, AvailableForRent, AdOnOtherWebsites, Staff_No*, S_Name*) 1. For each of these relations, write down all functional dependencies. If there are nofunctional dependencies among attributes, you must state so. Subject: MYSQL
RosterGrades=readtable('RosterScores.txt'); RosterGrades.Grades=cell([size(RosterGrades,1),1]); for i=1:size(RosterGrades,1) if RosterGrades.Scores(i)>=90 RosterGrades.Grades{i}='A'; elseif RosterGrades.Scores(i)>=80 RosterGrades.Grades{i}='B'; elseif RosterGrades.Scores(i)>=70 RosterGrades.Grades{i}='C'; elseif RosterGrades.Scores(i)>=60 RosterGrades.Grades{i}='D'; else RosterGrades.Grades{i}='F'; end end RosterGrades writetable(RosterGrades,'RosterScores.txt')
R language Show the specific department has the highest the highest admission on UCB admission dataset available in R language For example ( department A has the highest admission) Please answer it with code, thanks
Veterinarian Office Case: Part 5 The veterinarian office created a database to keep track of owner and pet information. It also includes tracking appointments and treatments for each pet. Unfortunately, the veterinarian database was not created correctly and needs modification. Read the question and select the correct dropdown to answer the question. Owner OWNER_ID OWNER_FNAME OWNER_LNAME OWNER_ST_ADDRESS OWNER_CITY OWNER_STATE OWNERE_POSTAL_CODE OWNER_PHONE OWNER_EMAIL 1 Melissa Canton NULL NULL NV NULL NULL NULL 2 Clay Sheperd Lousetown Road VC Highlands NV 89521 3456789 chsep@gmail.com 3 Helen Harvey 345 Pine Road Reno NV 89521 3451234 hharvey@gmail.com 4 April Windon 123 Doughton Road Reno NV 89521 3454879 awindon@gmail.com 5 Emily Minden 540 Fandango Pass Road VC Highlands NV 89521 3455190 emindn@gmail.com Pet PET_ID PET_BREED PET_NAME OWNER_ID…
Relation: Relation is a two-dimensional table in which data is named. The relations have the named columns and numbers which denote the unnamed rows. Although relation is defined as the two-dimensional table of data, not all the tables are considered as relations. There are some properties that differentiate relation tables from non-relation tables.
Break the list in Figure 1-31 into tables, each with a single theme. Create ID columns as you think necessary.