Reference no: EM131303790
Assignment -
You are required to develop a hybrid database system for a Hospital. As part of your assessment, you are required to submit the following:
Part 1: Report
The report must include the following:
- Background of your chosen system. Scope including business requirements.
- A list of business rules for the system (at least 5 implemented must be implemented).
- A database model for the hybrid database system. The model (relational schema) of your database must fulfill the requirements of 3NF. It must be based on an Entity Relationship Diagram (ERD) for the database application using the ER/EER modelling techniques (include a minimum of 4 entities displaying all the relationships with cardinalities and all constraints. At least one entity must contain an attribute with XML data type.
- Critical evaluation of your database design, highlighting the strengths and weaknesses.
- Report must be well-structured with Conclusions and Bibliography. Screenshots and explanation must be provided where required.
Part 2: Completed Database System
Develop a SQL Server database system based on the schema developed as part of the assessment. Your database must include the following:
- Tables with relationships using some referential integrity constraints. There should be a minimum of 4 substantial tables and any number of smaller tables that you require to implement your database. Tables should be linked using an appropriate method in SQL Server. Each table must have a minimum of 5 test records per table. In your report explain which referential integrity constraints are used and why?
- At least one table with an appropriate field with the proper use of XML data type.
- Queries to meet the business requirements. The queries must include:
i. A query that retrieves data from one or more tables.
ii. A query that retrieves data from two or more tables.
iii. A query that retrieves aggregate data based on certain criteria.
iv. A query that retrieves data based on certain pattern
v. A query that generates XML document from SQL records.
vi. A query that retrieves data logically from a field with XML data type as well as data from fields from other data types.
vii. A query to update data in a field of XML data type.
viii. Any other queries to fulfill the business requirements.
Note: All these queries must be developed as "Stored Procedures". Four stored procedures must use parameters.
- Two triggers to demonstrate the implementation of business rules.
- Two Views to demonstrate the development of virtual tables and their advantages.
Explain what is meant by open position and open interest
: Explain what is meant by open position/open interest. Why does the open position/open interest usually decline during the month preceding the delivery month? On a particular day, there are 2000 trades in a particular futures contract. Of the 2000 tra..
|
Does the short-run aggregate supply curve also have to shift
: If the short-run aggregate supply curve shifts, does the long-run aggregate supply curve also have to shift? (Hint: Consider the factors that shift each curve and determine whether these factors also shift the other curve.)
|
What are components of a specific emotion like love or fear
: What are the components of a specific emotion like love or fear? What are the advantages of an emotion like love or fear? Cockroaches may lack emotions yet they manage to reproduce and escape threats pretty well.
|
Construct the discrete variation equation for the element
: Consider a bar element as shown in the figure.- The cross-sectional areas are A1 and A2 at nodes 1 and 2, respectively, and vary linearly.- Construct the discrete variation equation for the element.
|
Develop a hybrid database system for a hospital
: You are required to develop a hybrid database system for a Hospital. The report must include the following: Background of your chosen system. Scope including business requirements. A list of business rules for the system (at least 5 implemented must ..
|
Who has a firm basic understanding of genetics and cell
: If abstracts summarize the work for a mostly expert audience, think of this exercise as a summary for someone who has a firm basic understanding of genetics and cell and molecular biologist.
|
What is the value of the equity of corporation
: T Corporation is considering the acquisition of M Corporation. M Corporation generates earnings before interest and tax of $1.75 million a year, and asset replacement cost approximately equals depreciation. Assuming year-end cash flows, what is the v..
|
Derive the interpolation functions
: For the Euler beam element shown in the figure, derive the interpolation functions, NI(ξ), stiffness matrix, k, and nodal force vector, f. Assume that the uniformly distributed load is f(x) = f.
|
What are inventories
: What are inventories? Briefly explain what happens to the level of inventories when aggregate expenditure is greater than real GDP, what happens when aggregate expenditure is less than real GDP, and what happens when aggregate expenditure is equal..
|