Develop an enterprise data model

Assignment Help Database Management System
Reference no: EM132928290

MITS4003 Database Systems - Victorian Institute of Technology

Objectives This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to improve student presentation skills, enhance students experience in researching a topic based on the learning outcomes they acquired during lectures, activities, assignment 1 and assignment

2. Furthermore, to evaluate their ability to identify the latest research trends and writing a report relevant to the Unit of Study subject matter. This assessment covers the following LOs.

1. Synthesize user requirements/inputs and analyse the matching data processing needs, demonstrating adaptability to changing circumstances;

2. Develop an enterprise data model that reflects the organization's fundamental business rules; refine the conceptual data model, including all entities, relationships, attributes, and business rules.

3. Derive a physical design from the logical design taking into account application, hardware, operating system, and data communications networks requirements; further use of data manipulation language to query, update, and manage a database

4. Identify functional dependencies, referential integrity, data integrity and security requirements; Further integrate and merge physical design by applying normalization techniques;

5. Design and build a database system using the knowledge acquired in the unit as well as through further research on recent trends to demonstrate competence in various advanced tasks with regard to modelling, designing, and implementing a DBMS including Data warehousing, Data Management, DB Security.

Presentation and Participation

For this component you will be required to do a 5-10-minute presentation on an academic paper on Database Systems, Data Mining or Data Analysis. The paper you select must be directly relevant to these 3 topics. The paper can be from any academic conference or other relevant Journal or online sources such as Google Scholar, Academic department repositories etc... All students must select a different paper; thus the paper must be approved by your lecturer or tutor before proceeding. In case two students are wanting to present on the same paper, the first who emails the lecturer or tutor with their choice will be allocated that paper.

The presentations will occur in sessions 9-12 on the academic calendar and the order of presentations will be by arrangement, but these will be evenly spread over those sessions.

Research Report

For this component you will prepare a report or critique on the paper you chose from the Presentation and Participation component above.

Your report should be limited to approx. 1500 words (not including references). Use 1.5 spacing with a 12-point Times New Roman font. Though your paper will largely be based on the chosen article, you can use other sources to support your discussion. Citation of sources is mandatory and must be in the Harvard style.

Your report or critique must include:

Title Page: The title of the assessment, the name of the paper you are reviewing and its authors, and your name and student ID.

Introduction: A statement of the purpose for your report and a brief outline of how you will discuss the selected article (one or two paragraphs). Make sure to identify the article being reviewed.

Body of Report: Describe the intention and content of the article. If it is a research report, discuss the research method (survey, case study, observation, experiment, or other method) and findings. Comment on problems or issues highlighted by the authors. Discuss the conclusions of the article and how they are relevant to what you are studying this semester.

Conclusion: A summary of the points you have made in the body of the paper. The conclusion should not introduce any ‘new' material that was not discussed in the body of the paper. (One or two paragraphs)

References: A list of sources used in your text. They should be listed alphabetically by (first) author's family name. Follow the Harvard style. The footer must include your name, student ID, and page number.

Attachment:- Database Systems.rar

Reference no: EM132928290

Questions Cloud

Analyze the main ways in which various environmental factors : Analyze the main ways in which various environmental factors may influence the medical examination and autopsy in death investigations.
Difference between judgmental and statistical approaches : 1. What is the difference between judgmental and statistical approaches to the collection and combination of applicant information?
Examine the role of the law enforcement administrator : Examine the role of the law enforcement administrator or leader (e.g., sheriff, police chief) in protecting the community from a terrorist incident.
Major health and safety issues of global firms : Discuss any FIVE (5) of the major health and safety issues affecting international assignees of global firms internationally.
Develop an enterprise data model : Develop an enterprise data model that reflects the organization's fundamental business rules; refine the conceptual data model, including all entities
Identify the criminological theory and the criminal type : Identify the criminological theory and the criminal event/type of crime you selected. analyze the criminal event or type of crime you selected.
Explain the potential consequence for a business : Explain the potential consequence for a business of an ineffective approach to training and development of employees
What financial reporting cycles can be used by organisation : Explain the purpose of each of the following: a cash flow budget, a capital expenditure budget, What financial reporting cycles can be used by organisation
Analyze both the court system likely view on the accused : Analyze both the court system's likely view on the accused's rights, as well as the court system's likely treatment of the defendant during trial proceedings.

Reviews

len2928290

6/28/2021 4:13:15 AM

In total, Section A will be 300 words and section B will be as per the requirements. add a powerpoint slide to the 2nd section - No. of slides 2

len2928290

6/28/2021 4:13:09 AM

2. Decision making regarding the most appropriate form of risk treatment for the risks identified 3. Application of suitable controls to achieve the objectives determined earlier 4. Acceptance of any residual risk following the implementation of the controls applied Hypothetically consider a specific health care information used in real-time and apply the above steps, narrate the risk management process that you would recommend. just the first section A needs to be 300 words the second section B doesnt matter with how many words

len2928290

6/28/2021 4:12:36 AM

its a Masters class A. Submit your answers for the following questions in no less than 300 words. 1. Is taking account of information risk beneficial to an organization, if so why? 2. List at least 5 benefits and give examples in health care setting? B. Information risk management process consists of 4 key steps. 1. Identification and qualification of inherent risk

Write a Review

Database Management System Questions & Answers

  You were hired as an analyst to develop a new information

you were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size

  Create a one to many relationships

Create a report from the query above. Format the report so that each time a report is prepared, the sales rep's name will appear on the report

  What normal form is this relation currently in

What normal form is this relation currently in? Describe the specific modification anomalies that exist if we DELETE the tuple containing Stewart.

  Identify candidate keys of employee

Identify candidate keys of EMPLOYEE. Construct a decomposition of EMPLOYEE into relations in 3NF that preserves dependencies.

  Design and implement the best deal business database

Design and implement the Best Deal business database that you have modelled in the assignment-1 and a series of SQL queries to reflect the business logic of the Best Deal.

  Develop an er model for the data management

Implement the data modelling for a database that is based on the application scenario - develop an ER model for the data management

  What is an overlapping subtype

What is the difference between partial completeness and total completeness?

  Comprise a justifiable argument for use of data warehouse

Comprise a justifiable argument for the use of data warehouses, data centers, and data marts in order to support for business intelligence (BI) within the organizational structure.

  Create form to search for the title of a video

Create this form to search for the title of a video. Create the necessary Video table (with about 5 or 6 records in the interest of time) with the fields shown. Use any images you can find.

  Complete the wild wood apartment scenario

At the end of each chapter there is WILD WOOD Apartment scenario. The Wild wood apartment scenario involves creating a database to manage a chain of apartment buildings. Complete the WILD WOOD Apartment scenario for Chapter 5 to Chapter 7. Please ..

  Identify all possible relationships

Draw a Crow's Foot ERD, using proper notation, for the above scenario and Identify the connectivity for each relationship.

  Management studio for database design

1.Use the Management Studio to create a new database called MyWebDB using the default settings. (Ifthe database already exists, use the Management Studio to delete it and then recreate it.) 2. Use the Management Studio to create the following tables ..

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