Reference no: EM131385197
Chapter 2 Lab -Dipping a toe in SQL
Purpose
The purpose of this lab is to get comfortable with SQL. Do the two debug assignments on Blackboard FIRST
Overall Description
You will create a small database in 2NF in APEX that captures the following information:
Customer information including which products the customer has bought. Their identifying information (ID, First Name, Last Name, Address, Phone Number, and three other pieces of information you may want to capture) and three other pieces of information.
Productinformation including which customers have bought the product, which department the product is from, how much it costs to buy, how much we sell it for, the productID. In addition to these fields, three extra pieces of information.
Please keep in mind it is up to you design how this information is stored and in which tables. What is listed above is NOT going to be your table schema...it's just pieces of information you need to capture. For example, you may need to add junction tables if the connections are many to many. The specs above give you the information that needs to be available. How you decide to store these in tables is completely up to you.
What to do
Use the slides and other information provided to you to create a small database in APEX by using SQL commands
Deliverable
- The script used to create your database in a .txt file uploaded to Blackboard
- A one-page report explaining your database design (including why it is in 2NF) single spaces calibiri font 11 or equivalent.
|
Analyze proper physical access control safeguards
: Imagine you are an Information Security consultant for a small college registrar's office consisting of the registrar and two (2) assistant registrars, two (2) student workers, and one (1) receptionist. The office is physically located near severa..
|
|
Different types of risk that a business may encounter
: Define risk, and then distinguish between pure risk and market risk.- What are the different types of risk that a business may encounter?
|
|
Analyze past and present quality initiatives
: Discuss past and present funding for initiatives that address the health issue (Malaria) include both public and private sources. Analyze past and present quality initiatives that address the health issue (Malaria) include both public and private so..
|
|
Is it logical for small business to utilize self insurance
: Can a small company ever safely assume that business risks will never turn into losses sufficient to bankrupt it? Why or why not?
|
|
Create a small database in 2nf in apex
: You will create a small database in 2NF in APEX that captures the following information:Customer information including which products the customer has bought. Their identifying information (ID, First Name, Last Name, Address, Phone Number, and th..
|
|
Describe a business owners policy
: Describe a business owner's policy. List the advantages of this type of policy, and tell what types of insurance coverage are available with a BOP.
|
|
How does the organization motivate its employees
: How does organization motivate its employees? Describe any programs or methods they use to motivate workers. If the organization does not have any employee motivational strategies, suggest some strategies that you think will be effective.
|
|
Calculate delinquency rates for health records
: Professional Practice Activities (PPA) are activities designed to expose you to real, sometimes virtual, professional/healthcare practices. For students enrolled in the Health Information Technology Program, PPAs are a required part of the curricu..
|
|
Explain the role of a business appraiser
: Explain the role of a business appraiser.- When setting a price for a small business, what must one consider?
|