Design and implement a hybrid database system

Assignment Help Database Management System

Reference no: EM132345490

Assessment - Design and implementation of a hybrid (Relational/XML) database system of your choice.

You are required to design and implement a hybrid database system for a company/business of your choice (real or virtual). As part of your assessment, you are required to submit the following:

Report:

The report must include the following:

• Details of the chosen system.Scope of the database. Seven business requirements.Screen shot must be included to demonstrate the execution of each business requirement (through stored procedures).

• A list of business rules for the system (at least 4must be implemented using SQL code instead of showing at design stage).The implementation must be shown by the screenshots in the report.

• Relational Schema for the hybrid database system (must be developed in Visio or some similar system using crow's foot notation or UML notation). Relational schema must fulfill the requirements of 3 NF, you must provide the justification in report. It must include fivesubstantial tables using XML data type in at least one table (or more) as appropriate. Justify the use of XML data type that makes it a hybrid database.

• Report must be well-structured with Conclusions and Bibliography. Screenshots and explanation must be providedfor all requirements and business rules.

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 five 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? Include Data Diagram that must match relational schema. Code must be included in appendix.

• All queries must be written using stored procedures (with parameters) to meet the business requirements. The queries that meet business requirements must include the following features:
i. Use of JOIN between two or more tables as required
ii. Use of GROUP BY with HAVING
iii. Use of SQL functions
iv. Developing XML with appropriate elements using relation fields
v. Retrieving data logically from a field with XML data type as well as data from fields from other data types.
vi. Modifying data in a field of XML data type.
vii. Searching data in a field of XML data type.
• Two triggers to demonstrate the implementation of business rules.
• Two Views to demonstrate the development of virtual tables. How Views would be helpful to generate customised View of your data?

Innovation

Use of any other features to enhance theusability of your database system.

For Example, Put Front End and Create formatted reports to enhance usability of the system and mention it in your report.

Reference no: EM132345490

Questions Cloud

Explain world systems theory and construct list of countries : Explain World systems theory and construct a list of countries in each of the three categories. identified four combinations of prejudice and discrimination.

Which of the following would appear on the income statement : Under the Sarbanes-Oxley Act, accounting firms are prohibited from both auditing a client and providing certain consulting services for the same client.

What are the challenges as the firm evolves through each : Describe and rationalize how a firm's logistics and supply chain strategy will likely evolve as a firm shifts from no international to a global strategy

Explain differences between the service models IaaS and PaaS : ITC561 Cloud Computing Assignment, Charles Sturt University, Australia. Explain the differences between the service models IaaS and PaaS

Design and implement a hybrid database system : B9IS100 - Advanced Databases - Dublin Business School - MSc Information Systems with Computing - Design and implement a hybrid database system for a company

What is interesting about how technology : What is interesting about how technology, politics and geography interacts in NYC?

Discuss advantages and disadvantages of computer networking : In a 1-2 page APA research paper, discuss the advantages and disadvantages of computer networking, for both personal and business environments.

Explain how geography interacts with sociology : Explain how geography interacts with sociology

Identify and discuss a real-world application of bi : Identify and briefly discuss a real-world application of BI? (Need 2 discussions each 250 words total 500 words)no plagarism. The response must be typed.

Reviews

len2345490

7/25/2019 12:16:22 AM

General Assessment Submission Requirements for Students: 1. Online assignments must be submitted no later than the stated deadline. 2. All relevant provisions of the Assessment Regulations must be complied with. 3. Extensions to assignment submission deadlines will be not be granted, other than in exceptional circumstances. download the Assignment Extension Request Form. 4. Students are required to retain a copy of each assignment submitted, and the submission receipt. 5. Assignments that exceed the word count will be penalised. 6. Students are required to refer to the assessment regulations in their Student Guides and on the Student Website. 7. Dublin Business School penalises students who engage in academic impropriety (i.e. plagiarism, collusion and/or copying). Please refer to the attached referencing guidelines for information on correct referencing.

7/25/2019 12:16:04 AM

Criteria/ Mark Report 70 + Excellent solution to problem proving originality, creativity and evidence of research – very well written with excellent data model and normalised schema to 3NF Database System Excellent database system that meets all the business requirements, required features, etc.

Write a Review

Required(*) Message

User Account

All Pages