Create a Windows Forms application. Use the following names for the project and solution, respectively: Adaline Project and Adaline Solution. Save the application in the VB2017\Chap08 folder. Create the interface shown in Figure 8-54. The figure also contains the major tasks that the application needs to perform. Code the application. Save the solution and then start and test the application. Tasks 1). Declare a class-level Integer array to store the sales amounts for the following salespeople. You can create either a two-row, six-column array or a six-row, two-colurnn array.

Create a Windows Forms application. Use the following names for the project and solution, respectively: Adaline Project and Adaline Solution. Save the application in the VB2017\Chap08 folder. Create the interface shown in Figure 8-54. The figure also contains the major tasks that the application needs to perform. Code the application. Save the solution and then start and test the application. Tasks 1). Declare a class-level Integer array to store the sales amounts for the following salespeople. You can create either a two-row, six-column array or a six-row, two-colurnn array.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

1st Edition

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Chapter11: Building Solutions: Database, System, And Application Development Tools

Section: Chapter Questions

Problem 23CT

See similar textbooks

Similar questions

SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345
Suppose that you are given a database that records information about human resources of a large multi-national company. You can find the enhanced en- tity relationship diagram of this database below. Answer the following question by writing am SQL query on this database. You are given an example output for the question. Records with '9999-01-01’ as their to date attribute are the current ones. salaries employees titles emp_no INT(11) emp_no INT(11) emp_no INT(11) salary INT(11) O birth_date DATE %23 title VARCHAR(50) from_date DATE first_name VARCHAR(14) from_date DATE to_date DATE last_name VARCHAR(16) O to_date DATE Indexes gender ENUM(M', F) Indexes PRIMARY hire_date DATE PRIMARY PRIMARY dept emp emp_no INT(11) dept_manager Kdept_no CHAR(4) O from_date DATE emp_no INT(11) departments dept_no CHAR(4) dept_no CHAR(4) to date DATE O from_date DATE O dept_name VARCHAR(40) KIndexes O to_date DATE Indexas PRIMARY Indexes PRIMARY dept_no PRIMARY dept_name dept no Find the first names and…
Member ID 1582 2587 3549 9536 2567 2154 3265 8765 3259 6540 First Name Mara Philip Kathleen Sau Shanice Chase Tommie Dorcas Angel Weston BookingID 1 2 3 4 5 6 7 8 Table 1: Member Last Name Gender Age Female 25 Male 36 Female 25 United States Female 25 United States Hashimoto Gent Hanner Pfau Mccrystal Karner Jia Darity Sanor Martina Room Room 15 Room 25 Room 1 Room 15 Room 5 Room 21 Room 3 Room 8 Date 29-Dec-2020 9-Dec-2021 3-Mar-2019 4-Sep-2021 13-Feb-2021 6-May-2021 10-Nov-2020 4-Apr-2022 Table 2: Booking Days 2 4 6 5 10 6 5 Female 36 Male 37 Male 26 Female 37 Male 24 Male 23 4 Table 3: Make MemberID 3549 9536 6540 2154 2567 2154 3265 1582 $150.00 $80.00 $120.00 $300.00 Country Uganda France 3 4 China Australia United States United States Cost per day $200.00 $80.00 $80.00 $150.00 5 6 7 8 France China BookingID 1 2 Joined Date 16-Aug-2020 21-May-2015 12-Dec-2017 16-Aug-2019 16-Aug-2020 1-Jan-2021 29-Dec-2018 21-May-2019 4-Mar-2019 1-Feb-2022 Status Paid Paid Pending Paid Pending Paid…
SALES REP RATE POSTAL CELL PHONE COMMISSION CITY STATE ADDRESS REP ID FIRST NAME LAST NAME 0,04 WY 82414 307-824-1245 $12,743.16 Susan Garcia 42 Mountain Ln Cody 05 82440 307-406-4321 $20,872.11 0.06 Miller 87 PIkes Dr Ralston WY 10 Richard $14,912.92 0.04 Powell WY 82440 307-982-8401 15 Donna Smith 312 Oak Rd Elk Butte WY 82433 307-883-9481 S0.00 0.04 20 Daniel Jackson 19 Lookout Dr CUSTOMER CITY STATE POSTAL EMAIL BALANCE CREDIT REP ADDRESS CUST FIRST_ ID LAST NAME LIMIT ID NAME 125 Joey 17 Fourth St Cody WY 82414 Jkmlth17@exmple S80.68 $500.00 05 Smith Com 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyrufi@example $13.13 $750.00 10 :Com. 227 Bandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example $156.38 $500.00 15 com 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@exnmple $58.60 $500.00 10 Com Rasenl 1 Raseal Рarm Rd Cody 314 Tom WY 82414 traseal3@example $17.25 $250.00 15 .com 375 Melanle Jnokson 42 Blaokwater Way 16 Rockwny Rd Elk Butte WY mjackson5@ example.com…
Branch branchNo street city postcode sWI 4EH 16 Argyll St Aberdeen AB2 3SU GI1 9QX BO05 22 Deer Rd London BO07 BO03 163 Main StGlasgow BO04 32 Manse Rd Bristol BS99 INZ BO02 56 Clover Dr London NW10 6EU Foreign key Staff staffNo fName IName| position salary branchNo sex DOB SL21 John White Manager Assistant M 1-Oct-45 30000 BO05 SG37 Ann Beech 10-Nov-60 12000 вооз SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant 19-Feb-70 9000 BO07 SG5 Susan Brand Manager 3-Jun-40 24000 BO03 SLA1 Julie Lee Assistant 13-Jun-65 9000 BO05 Tuple Degree Candidate Key Cardinality Domain Attributes Drag and drop the proper terms Relation Relation
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE 6/1/1999 Male 12/30/1994 Female 6/1/1999 Male 5/6/1995 Male 10/15/1992 Male S103 Hisham 90 D102 A102 Level 1 22 S102 Sara 45 D103 A104 Diploma 27 S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 s100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 S104 Faisal 4/5/1998 Male 90 D104 A101 Advanced Diploma 23 S105 Fatima 2/23/1992 Female 90 D102 A102 Level 2 29 9/12/1999 Female 8/13/1991 Female S106 Arwa 45 D102 A102 Level 3 22 S108 Ibtisam 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level
PLEASE EXPLAIN IN DETAIL AND WRITE ELIGIBLY officeNo officeAddress telNo mgrStaffNo name B001 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels B002 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern Primary key: officeNo Why the above table is not in 3NF? Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). c) Identify the primary and foreign keys in your 3NF relations.
L Consultant ConsitNum LastName FirstName Street 19 Christopher Patrick Sarah Tom 35 $1 Client ClientNum ClientName 175 299 322 363 405 449 Turner Jordan Allen Shields 458 Hershey, Jarrod Goduto, Sean Two Crafty Cousins Prichard's Pizza & Salazar, Jason Fisherman's Spot Shop Seymour, Lindsey Bonnie's Beautiful Boutique Yates, Nick Howler, Laura Harpersburg Bank MarketPoint Sales Street 135 Mill Street 12 Saratoga Parkway 9787 NCR 350 West 501 Air Parkway 733 458 554 Brown Dr. 2287 Port Rd. 82 Elliott St. 373 Lincoln Ln. 322 867 322 363 867 826 677 733 826 867 WorkOrders OrderNum OrderDate ClientNum 67101 9/6/2018 67313 9/7/2018 9/10/2018 67424 67838 67949 68252 68868 68979 9/10/2018 9/10/2018 9/12/2018 9/14/2018 9/17/2018 4091 Brentwood Ln 9565 Ridge Rd. 231 Day Rd. 1368 E. 1000 S. 65 Forrest Blvd. 826 Host St. City Tri City Easton Lizton Sunland City Easton Tri City Sunland 68252 68868 68979 68979 Lizton 56473 Cherry Tree Dr Easton FL. 49 Elwood Ave. Harpersburg FL. Amo Tri City State…
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…
PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002MAR 27/2002APR 02/2002 01 - RABIES VACCINATION10 - EXAMINE and TREAT WOUND05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002MAR 10/2002 08 - TETANUS VACCINATION05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001JAN 13/2002 01 - RABIES VACCINATION01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002APR 30/2002 20 - ANNUALCHECK UP12 - EYE WASH The functional dependencies that I note are as follows: Pet ID --> Pet Name, Pet Type, Pet Age, Owner Pet ID, Visit Date --> {Visit Procedure} (the set of visit procedures), note the use of procedure codes that repeat, but are listed in their own column So, Is there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed. Please help me understand this.
The table below is how Magical Medical Place (MMP) keep track of the medication it givens to patients and the doctors that prescribed the medication. Doc ID Doc Name Pat Name Pat contact 321456 John 321457 Sarah Medication Price Quantity Reggy Samual 0861236548 Penicillin R200 10 0796549872 Antibiatics R400 20 Robafen Cough Doxycycline Penicillin Antibiotics Robafen Cough R10 40 321459 Mary 321460 Linda 321461 John 321462 Robert Susan 0116549875 R250 20 Reggy 0861236548 R200 10 0321789654 0987349165 R400 20 Queen Junior R10 25 3.1 In which normal form is the above table? Motivate your answer. 3.2 Identify a Primary Key and motivate why the identified attributes were chosen. 3.3 Provide all the dependencies of the given table. 3.4 Convert the table into the second normal form. 3.5 Convert the table into the third normal form. 3.6 Must is the purpose of Normalization? 3.7 Provide two(2) suggestions on how to improve the design of the table after they have been restructured into third…
Consider the following two tables: Table1: Products productID productName unitPrice entryDate expiryDate P1 Dell Laptop 350 16-10-2016 30-10-2016 P2 Apple mobile 420 17-02-2018 02-03-2018 P3 Samsung Mobile 330 20-08-2020 30-08-2020 P4 HP Printer 80 21-09-2019 05-10-2019 P5 Canon Printer 150 15-05-2020 20-06-2020 Table2: Orders orderID Quantity Price productID 1 10 3300 P3 2 5 1800 P1 3 20 1600 P4 4 20 3000 P5 5 9 1100 P7 6 8 2250 P10 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it). 1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p INNER JOIN Orders AS o ON p. productID = o. productID; 2. SELECT p. productName, p. unitPrice, p.…