Implementation of batch file to create and populate database

Assignment Help PL-SQL Programming
Reference no: EM131415051

You are required to demonstrate advanced knowledge of Views, Stored Procedures, and Batches as follows:

You must write a batch file which creates and populates a database of between 4 and 6 tables. The database must be of your own making and should be of an area of interest to you or related to your work. The database must be stored in a folder which is named after yourself. As well as creating tables, the batch file must cater for keys.

The number of records to be inserted can be decided by yourself but should be enough only to warrant successful demonstration and execution of your queries. Careful consideration, therefore, should be given to the type and amount of data you wish to store.

You are then required to have a separate SQL file which demonstrates the use of Views and Stored Procedures. No more than 8 queries should be used to demonstrate Views and no more than 12 queries should be used to demonstrate Stored Procedures - enough to demonstrate advanced knowledge of both.

The code inside both views and stored procedures must be complex and include joins, subqueries, aggregate functions etc.

Furthermore, specifically relating to Stored Procedures you must demonstrate advanced use of parameters, insert operations, error handling and the use of return.

Basic documentation should be provided with the batch file, detailed documentation with everything else (outlining what the code does, why you believe it to be advanced, issues you encountered and overcame/did not overcome, links to websites/articles you found useful etc.). The provision of business cases is not a requirement for this assignment.

Reference no: EM131415051

Questions Cloud

What is another interpretation or viewpoint of the issue : How can I validate the accuracy of my statement? How is this information relevant? How does my conclusion address the complexities of the issue? What is another interpretation or viewpoint of the issue?
Ethics-social responsibility what a fraud : The economy is tight, and there is competition among applicants to land jobs. This setting is expected to lead to an increase in the number of applicants who will misrepresent their background and credentials. The hope, of course, is that this bit of..
Clinical maintenance for the clinical reminder : Review the clinical maintenance for the clinical reminder, mammogram screening. Why does Karen have the clinical reminder for a mammogram screening?
Why does the term latent conflict : Raid on the student activity fees fund Why does the term "latent conflict" describe the situation that exists on this board? What could make this conflict move out of a latent stage into an open conflict? What examples can you give of latent conflict..
Implementation of batch file to create and populate database : You must write a batch file which creates and populates a database of between 4 and 6 tables. The database must be of your own making and should be of an area of interest to you or related to your work. The database must be stored in a folder whic..
Expect the globalization backlash to grow stronger : Why do you think many people are so frightened by globalization? Based on what is occurring in the world today, do you expect the globalization backlash to grow stronger or weaker? Why do national cultures differ and why is it important that managers..
Actively participate within the brainstorming activity : Everyone knows that productive brainstorming sessions are imperative to creating stellar presentations. Everyone also knows that the practice of brainstorming has become a little weary. Our brains are over-stimulated and tired. Which brainstorming ac..
Why is slow adoption of ehr a potential problem an issue : Why is slow adoption of EHR a potential problem in long-term care healthcare an issue? Why might the warning given by Office of National Coordinator for Health Information Technology present a problem to those in nursing and senior living business?
Identify one complaint that guests will frequently register : Identify one complaint that guests will frequently register with the guest-service agent at the front desk, and offer a best-practice response that management has prepared in anticipation of the complaint.

Reviews

len1415051

3/6/2017 12:54:35 AM

Please use SQL SERVER 2014. Marks are allocated as follows: Implementation of a batch file to create and populate a database, Creation and use of Views, Creation and use of Stored Procedures. Basic documentation should be provided with the batch file, detailed documentation with everything else (outlining what the code does, why you believe it to be advanced, issues you encountered and overcame/did not overcome, links to websites/articles you found useful etc.). Submission: Place the two SQL files into a folder named after yourself (i.e. FirstName_LastName_StudentID), compress (zip)this folder.

Write a Review

 

PL-SQL Programming Questions & Answers

  Good example of sql query

Explain what is bad about the poor example

  Question 1 calculate the tax on an ordercomplete the

question 1. calculate the tax on an ordercomplete the following steps to create a procedure to calculate the tax on an

  Assignment related to sql querries

Write a SELECT statement that returns these columns from the Products table: The DateAdded column, A column that uses the CAST function to return the DateAdded column with its date only (year, month, and day)

  Create a procedure that returns the most recent order status

Create a procedure that returns the most recent order status information for a specified basket - Create a procedure named DDPROJ_SP that retrieves project information for a specific project based on a project ID. The procedure should have two para..

  Illustrate the process of normalizing

Evaluate if the table shown above is normalized, if not describe and illustrate the process of normalizing the table shown above to third normal form. State any assumptions you make about the data shown in this table.

  Create a view named customer addresses

Create a view named CustomerAddresses that shows the shipping and billing

  Calculate days between ordering and shipping

Calculate the Tax on an Order, Calculate the Total Shopper Spending - Develop a SELECT statement using the BB_SHOPPER table to produce a list of each shopper in the database and his or her respective totals.

  Process of normalization to transform

Use the process of normalization to transform the table below into 3NF. Show the tables in 1NF and 2NF that are created in the process.

  Build cross-cultural awareness

Working across cultures can be enriching and meaningful. Colleagues can build cross-cultural awareness by engaging with people who are similar to and yet different from them. At the same time, working across cultures also has its challenges.

  Construct an sql schema definition for database

Construct an SQL schema definition for this database. Use inheritance where appropriate.

  Write the sql ddl to create the database

Write a command that will remove the Jones that lives in Orange from the Customer table .Write the SQL DDL to create the database that contains each of the relations shown in the above ERD.

  Create an index used for this query.save your sql in a file

Create an index that will be used for this query and therefore speed up its response time. Save your SQL in a file.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd