Lab 1 – Databases, Schemas, and Basic Tables

For this lab we will be creating a small Student Loan Database.

Make sure to open your screenshot word document. Include the required screenshots of your code in the document.

Database: Create a new database: StudentLoan_LastName.
Schemas: Create the following schemas. Make sure to screenshot and run your code:

1. Student
2. Guarantor 3. Institution 4. Activity
5. Loan
6. Lender

Tables: First complete the word document for designing the tables like we did in the slides. Use the information below to complete the file.

Note the schemas the tables are associated with:

Schema. Table Name

Student tblStudent

Guarantor.   tblGuarantor

Institution.   tblInstitution

Activity. tblActivityReport

Loan.   tblLoan tblLoanStatement

Lender. tblLender

Finally, write and screenshot the code for creating the following tables in your database. Make sure to run the code to create the tables:

tblStudent –include the student’s names, date of birth, and gpa.

tblGuarantor – include the guarantor’s name, address, city, state, zip, and phone

number.

tblInstitution – include the institution’s name, address, city, state, zip, and phone number.

tblActivityReport - include the name of the activity, begin date for activity, end date for activity, and how much the activity costs.

tblLoan – include the name of the loan type, the amount of the loan, the begin date of the loan, the id of the guarantor of the loan, the id of the lender for the loan, and the id of the student who took out the loan.

tblLoanStatement – include the amount of the loan, the id of the student who took out the loan, the amount of money the loan is for, the graduation date of the student, and the monthly payment amount for the loan.

tblLender – include the lender’s name, address, city, state, zip, and phone number.

Backup the database file, zip it.

Submit the following:

1.the zip of your database file

2.the table creation word document

3.the code screenshots document

Grading Rubric:

Grade item   Points

Create correct database 10pts

Create all 6 schemas   20pts

Create and associate the correct tables with their schemas. Make sure to use correct data types. 30pts

Screenshot Document   15pts

Table Creation Document   25pts

Total   100pts

Deductions

Exact Same Code/Documents as Another Student   -10pts per infraction or 0 on assignment

Word Documents Not Named Correctly   -5pts per document

Incorrect database name used   -10pts

Formatting changed in Word Documents -10pts per document

Using your own Word Document instead of the one provided   No points for docs

Database Backup/Word document Incorrect/Unreadable -100pts

Enumerate 5 items that you must maintain update in the maintaining surgical supplies

Search on the following three phrases:

• Insertion Anomaly
• Update Anomaly
• Deletion Anomaly

1.  Several ASU's have been issued by the FASB over the last several years. Accounting Standards Update No. 2015-01 Extraordinary and Unusual Items was issued in the beginning of 2015.

Required: (Address only extraordinary items in your answer.)

1.What was the reason for this update?

2.What was the standard before and how has it changed the presentation of extraordinary items?

3.Do you think this is an improvement? Give two reasons for your answer.

void Stack :: push(float x)
{
  if (count _______ capacity)                                                    // If there is no room for a new value
{
float* new_A = ______ float[ 2 * ________ ];                     // Create a new array with two-fold capacity
for (int i = 0; i < count; ++i)                                   // Copy existing data to new array
_______= A[i];
delete[]__________ ;                                                          // Delete old array
A = new_A;                                                            // Connect to the new array
capacity *= _______ ;                                                    // Update the capacity
}
A[ ______] = x;                                                                   // Insert the new item onto the stack
++ ________ ;                                                                          // Update count of items in the stack
}

The National Database of Nursing Quality Indicators is an example of a database that collects nurse-sensitive indicators and patient outcomes at the same point in time. This allows analysts and decision-makers to place the results in context. In other words, did that patient fall occur when the staffing levels were low? Review the information on the NDNQI site and discuss how you would use these data to make decisions regarding administration and patient care.

1. How to generate database diagram for a database that stores information about the downloads that users make.

Each user must have an email address, first name, and last name.

Each user can have one or more downloads.

Each download must have a filename and download date/time.

Note: I want steps on how to generate this diagram using oracle SQL developer

Each product can be related to one or more downloads.

Each product must have a name.

Use MYSQL to create the set of database tables of the relational database model and complete the associated queries given.

Procedure: 1) Write all the SQL statements, necessary to create all tables and relationships, with Primary & Foreign keys.

2) Execute each statement in the correct order to create the relational database in MYSQL.

3)Insert some data into each table.

4) Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL WorkBench

5) Write in MS Word and execute in MYSQL WorkBench the statements necessary to; i. display all tables, ii. identify sales total for each item iii. identify delivery confirmation of sold items iv. identify marketing level for sold items

(Tables that have to be created)

• Sales details

• Marketing details

• Customer details

• Production details

• Delivery details

• Management details