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.
|
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.
|