Database Preparation: 1. Login MySQL 2. Create a database, its name must include your first and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Database Preparation: 1. Login MySQL 2. Create a database, its name must include your first and last name. See example below if your name is John Smith the database name should be John Smith Kim Tay 3. Use John Smith Kim Tay (again this is the database you created with your first and last name in previous step) 4. Run the script provided here (also in Brightspace) to create the database. Table descriptions, structures and records in the Kim Tay database can be found here (also in Brightspace). TASKS to Complete: 1. Create a table named REP. The table has the same structure as the SALES REP table in te Kim Tay database, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table.To see the structure of the SALES REP table, use the DESCRIBE SALES REP; command. 2. Add the following row to the REP table: rep ID: 35 first name: Fred last name: Kiser address: 427 Billings Dr. city: Cody state: WY postal: 82414 cell phone: 307-555-6309 commission: 0.00 rate: 0.05 Page: 1 DBA120 - Database Programming I Lab 3 3. Display the contents of the REP table. 4. Drop the REP table. 5. Check that the Kim Tay database is back to its starting point. The Kim Tay database should have the five tables at this point. Database Preparation: 1. Login MySQL 2. Create a database, its name must include your first and last name. See example below if your name is John Smith the database name should be John Smith Kim Tay 3. Use John Smith Kim Tay (again this is the database you created with your first and last name in previous step) 4. Run the script provided here (also in Brightspace) to create the database. Table descriptions, structures and records in the Kim Tay database can be found here (also in Brightspace). TASKS to Complete: 1. Create a table named REP. The table has the same structure as the SALES REP table in te Kim Tay database, except the COMMISSION and RATE columns should use the NUMERIC data type. Execute the command to describe the layout and characteristics of the REP table.To see the structure of the SALES REP table, use the DESCRIBE SALES REP; command. 2. Add the following row to the REP table: rep ID: 35 first name: Fred last name: Kiser address: 427 Billings Dr. city: Cody state: WY postal: 82414 cell phone: 307-555-6309 commission: 0.00 rate: 0.05 Page: 1 DBA120 - Database Programming I Lab 3 3. Display the contents of the REP table. 4. Drop the REP table. 5. Check that the Kim Tay database is back to its starting point. The Kim Tay database should have the five tables at this point.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
please make your Terminal window larger by resizing the window if you have not already done so so that we capture as much as possible (drag lower right corner with your mouse). Again note you may not...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Under unit-based absorption costing systems, are high- or low-volume products overcosted? Why?
-
What is the difference between a unitized production line and a link line?
-
A car starting from rest moves in a straight line with a constant acceleration of 2 . 1 0 m / s for 1 0 . 5 s , then travels with a constant velocity for another 1 4 . 5 s . How far does it travel...
-
The United States Centers for Disease Control and Prevention (CDC) recommends that adults sleep seven to nine hours per night (CDC.gov website). However, many adults in the United States sleep less...
-
An orchard has a acre of specialty fruit trees and is preparing for summer harvest. Historically, this acre has yielded and average of 1,800 lbs of fruit with a standard deviation of 800 lbs. A...
-
Consider the soil profile shown in Figure E3-2. The moist unit weight of the top sand layer is 20.0 kN/m. Capillary rise is present above the groundwater table. The saturated unit weights of clay 1...
-
Imagine that you work as a financial advisor. You have a client who would like to invest $750,000-in-bonds. You have narrowed down your options to the following list: The-interest-rate describes the...
-
Consider a rifle, which has a mass of 2.44 kg and a bullet which has a mass of 150 grams and is loaded in the firing chamber. When the rifle is fired the bullet leaves the rifle with a muzzle...
-
Q.2 Noble Industries Limited has two production departments and two service departments. Information regarding its factory overheads for the latest quarter and related details are as follows:...
-
Question: Management theories have developed over time. The management team of Starbucks is interested in the Quantitative approaches. Discuss the quantitative approach to management and the two...
-
Never connect the Positive (+) lead of a power supply to the ground. Connect the negative lead of the power supply to the circuit FIRST. Then, connect the positive lead. Parts: Breadboard DC Power...
-
7.22 The cash flows below were extracted from the accounts of Martin Jones, a music shop owner for the year ended 30 June 2023. Repayment of loan Sale of property Interest received Payments to...
-
Provide an example of two (2) of the following techniques or methods that you or someone that you know has endured or witnessed: Unfair recruitment, employment application, and interview process....
-
Following is the current balance sheet for a local partnership of doctors: The following questions represent independent situations: a. E is going to invest enough money in this partnership to...
-
The comparative statements of financial position of Borra Services as at 30 June 2024 and 2025 and the statement of financial performance for the year ended 30 June 2025 are shown overleaf....
-
The following comparative statements of financial position and statement of financial performance are for the business of Low Dollar Shop Pty Ltd. Additional information 1. All sales and purchases of...
-
The financial statements for the business of Autocare are shown below. Required (a) Prepare the statement of cash flows for Autocare for the year ended 30 June 2025, using the direct method. (b)...
Study smarter with the SolutionInn App