Perform the steps for sql coding and tuning efficiency

Assignment Help PL-SQL Programming

Reference no: EM131752562

Lab Assignment

You're working at ABankForYou...A bank that prides itself on its database systems and applications. You will be designing and implementing the database as well as three interactions for the system:

1) Check Balance
2) Deposit Money
3) Withdraw Money

Information that is stored in the system is as follows:

Each person has a name and an address. Each person also has the ability to have a checking and a savings account, although they don't have to have both, they MUST have one. The way the system handles overdrafts is completely up to you. An overdraft is when a person tries to withdrawl more money than they have in their account.

Your group is expected to design the entities for the system, design the database schema, input at least twenty users, and design the functionality as transactions for the three scenarios outlined above.

Deliverables:

- Entity Relationship Diagram
- Database schema (including indexed fields with documentation of why these fields were chosen to be indexed)
- Transaction descriptions

o Perform the steps for SQL coding and tuning efficiency (focus on tying the query to the business need)
o Queries for transactions

- Including what complexities, they possess (joins, etc...only the ones covered in lecture are necessary)

- Application design (on paper or powerpoint) showing what happens when each element is interacted with including which transaction is being performed

o You may consider turning in a separate document for each of the three interactions

- Show database statistics covered in class (From the GitHub from the book) for your system
- .sql file with database structure
- .sql file with data population
- .sql file with index creation
- .sql with queries included in transactions
- .sql with statistics
- A document from each individual letting me know what they, AND EACH GROUP MEMBER in their group did.

Reference no: EM131752562

Questions Cloud

Difference between positive and normative economics : What is the difference between positive and normative economics and what does neoclassical economics claim to be doing and why?

Analyze your personal writing process : Analyze your personal writing process and to discuss how the major assignments in this course illustrate your accomplishments

The list of chemicals identified as carcinogens continues : The list of chemicals identified as carcinogens continues to grow.What, in your opinion, are the two best ways to protect yourself from exposure to carcinogens?

Prepare a production cost worksheet : Jordana Woolens is a manufacturer of wool cloth. Prepare a production cost worksheet using the weighted-average method

Perform the steps for sql coding and tuning efficiency : Perform the steps for SQL coding and tuning efficiency (focus on tying the query to the business need). Including what complexities, they possess.

What is the period that the government-paid interest runs : What is the period that the government-paid interest runs with respect to Luis's claim for a refund?

What was the materials quantity variance : What was the materials quantity variance in August for bamboo

Determine the budgeted manufacturing overhead rate : The Wood Furniture Company manufactures tables. Determine the budgeted manufacturing overhead rate for each department

Problem related to stated discount rate on loan : On April 31, 2016, Elkhorn Associates borrowed $10 million cash from Colonial Bank and issued a 5-month, noninterest-bearing note, priced to yield.

User Account

All Pages