Programming with Microsoft Visual Basic 2017
8th Edition
ISBN: 9781337102124
Author: Diane Zak
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 12, Problem 4RQ
Program Description Answer
The statement SELECT Id, Status FROM Employ WHERE Status = ‘F’ retrieves the records from the table “Employ”, which have the status field as “F”.
Hence, the correct answer is option “A”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Given the tables:
reading
StationNo rainfall
mintemp
maxtemp
100
10
18
27
101
15
20
29
102
12
19
28
Stationregion
station
stationname
100
Savanne
101
Pamplemousses
102
Rose Belle
(i)
Write the statement to create the two table structures with the primary key as
the field underlined. You may decide on the size of the fields.
(ii)
Write the statement to enter the data.
(ii)
Write the statement to display all the records with the fields station.
stationname, mintemp, maxtemp .
Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname Fname DepartmentID 111 Ali Ahmed 1 112 Sana Waqar 2 113 Afzal Ikram 2 There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having: A) Structures, structure definitions and required initializations for the above scenario.
Department
DepartmentID
DName
ContactNo
1
UIIT
0300-1234567
2
UIMS
0300-4567891
Student
RollNo
Sname
Fname
DepartmentID
111
Ali
Ahmed
1
112
Sana
Waqar
2
113
Afzal
Ikram
2
There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having:
Structures, structure definitions and required initializations for the above scenario.
Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from user within the function, then verify that the DepartmentID exists in Department or not? If exists then copy DName and ContactNo in the student record along with above input, otherwise just display a message that department does not exists. For example the following record will not be allowed to store in the…
Chapter 12 Solutions
Programming with Microsoft Visual Basic 2017
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- The SERVICE_REQUEST table uses the CHAR data type for the DESCRIPTION and STATUS fields. Is there an alternate data type that could be used to store the values in these fields? Justify your reason for choosing an alternate data type or for leaving the data type as CHAR.arrow_forwardThe Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write a SELECT statement to select the year and the total number of movies for that year. Hint: Use the COUNT() function and GROUP BY clause. NOTE: Starter code has been provided. Simply change the blanks ("_") to the appropriate entity/value.arrow_forwardUsing the om database: Write a statement that displays these fields: customer’s first name customer's last name order id order date of orders placed Use the default JOIN type, use table aliases of C for customers and O for orders, and use the ON keyword when joining. The fields should be displayed in the order listed above. Notes: This statement requires joining tables together so I recommend you review the document provided titled 'Notes on database om'. Copy/Paste your answer from your Workbench into the textbox below Remove any "extra" spaces between each keywordarrow_forward
- Type Reduction in cell M1 The amount is 50% of sick days above 10, whenever sick days exceed 10. For all other records, the amount is 0 Create the criteria area, starting in cell P8 Enter formula(s) to complete column M, using an IF Statement.arrow_forward1a.Using SQL Terminal window write a query to display the names, block size of Control Files of your database. 1b.Using either SQL developer or SQL Terminal window write a query to display the names parameters related to UNDO. 1c.Using Database Express display the names, Status and Member count of Redo Log Groups.arrow_forwarduse sql to answer the following question Task 1: Creating a Logon Procedure The home page of the Brewbean’s Web site has an option for members to log on with their IDs and passwords. Develop a procedure named MEMBER_CK_SP that accepts the user ID and password as inputs, checks whether they match a valid logon, and returns the member first name+lastname and cookie value. The name should be returned as a single text string containing the first and last name. The head developer wants the number of parameters minimized so that the same parameter is used to accept the password and return the name value. (passwd Paramater as IN OUT use passwd as INPUT firstname||lastname as OUTPUT) Also, if the user doesn’t enter a valid username and password, return the value INVALID in a parameter named p_check. Test the procedure using a valid logon first, with the username rat55 and password kile. Then try it with an invalid logon by changing the username to rat and kile999 password. Hint:…arrow_forward
- Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.arrow_forwardin a shop ,there are 10 employee and 20 kinds of goods,goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?arrow_forwardLab 8-1: KimTay Pet Supplies Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the customer, and the invoice date for the invoice whose number currently is stored in I_INVOICE_NUM. Place these values in the variables I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE respectively. When the procedure is called it should output the contents of I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE. IN SQL CODE. CUSTOMER CUST_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT_LIMIT REP_ID 125 Joey Smith 17 Fourth St Cody WY 82414 jsmith17@example.com 80.68 500.00 05 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyruff@example.com 43.13 750.00 10 227 Sandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example.com 156.38 500.00 15 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@example.com 58.60 500.00 10 314 Tom Rascal 1 Rascal Farm Rd Cody WY 82414 trascal3@example.com 17.25 250.00 15 375 Melanie Jackson 42…arrow_forward
- herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraintsarrow_forward3. Write a SELECT statement that joins the Departments, Courses, and Instructors tables. This statement should return these columns: DepartmentName, CourseDescription, FirstName, and LastName. Use aliases for the tables and return only those courses with three units. Each course description should only be listed once. Sort the result set by DepartmentName and then by CourseDescription in ascending sequence.arrow_forwardWrite a SQL statement that will add the below row to the Task table.TaskID Description Duration StartDate TeamMemberID4 Implementemailnotifications2arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY