Reference no: EM131415039
Assignment Outline:
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.
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:
The code inside both views and stored procedures must be complex and include joins, sub-queries, 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.
|
Variables used for segmenting consumer markets
: Critically evaluate two variables/criteria that are often used in consumer segmentation. Segment a market of your choice and describe the derived groups (the segmentation should be theoretical and should be based on secondary sources and your perso..
|
|
What is the purpose of the exposure assessment
: What is the purpose of the exposure assessment? Why was the exposure assessment conducted? What type of sampling (personal or area) was conducted, and why?
|
|
Determine the basis of the ultimate cost of the payment
: Determine the basis of the ultimate cost of the payment to the lender to our company - For the purpose of this assignment you may ignore the carrying costs and the brokerage feesof the swap arrangement.
|
|
Estimate the external gas-to-particle mass-transfer
: At a location in the bed where the pressure is 653.3kPa, the temperature is 21°C, the gas flow rate is 1.327 kg/min, and the dew-point temperature is 11.2oC, estimate the external, gas-to-particle mass-transfer and heat-transfer coefficients.
|
|
Write a batch file which creates and populates a 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
|
|
Ethics based on nature and purpose of the consent
: Q1. What is the difference between law and Ethics based on nature and purpose of the consent, Illustrate with an example? Why informed consent is important in medical ethics? (Ref; Chapter 2)
|
|
What is the primary source of structured data
: Why does the data-information-knowledge continuum depend on structured data? What is the primary source of structured data? In what component of the EHR is structured data processed to provide information? In what component of the EHR is information ..
|
|
Compute the maximum speed of train
: a sub urban train runs with an average speed of 36km/hr between two stages 2km apart .values of acceleration and retardation are 1.8 km/h/s and 3.6km/h/s. compute the maximum speed of train assuming trapezoidal speed time curve.
|
|
Key issues of the cases
: Whirlpool's experience in China: What are the lessons learned? What are the new challenges when sourcing globally?
|