Evaluate the role of conceptual modeling

Assignment Help Database Management System
Reference no: EM131431455

Objective:

The assignment constitutes of the module mark. Assessment focuses on design and research issues related to Database Management Systems. Each student submits a detailed report as per the task specifications through Moodle.

The assignment has two sections (Part A and Part B) focusing on advanced database concepts: Part A focuses on analysis of key factors of database systems. In part B you are required to write a scholarly academic article based on critical engagement with work done in Part-A.

Outcome:

1. Evaluate the role of conceptual modeling in the development of database systems and apply the entity-relationship modeling approach to a realistic scenario

2. Apply the essential concepts of relational databases, (including keys, normalization and referential integrity) to sample data sets and demonstrate best practice in the development of an appropriate and effective database system

3. Select and apply appropriate techniques involved in database administration

4. Critically evaluate security issues relating to database management systems and propose appropriate strategies to address security problems

Part A

Scenario:

Aaliya Institute of Management and Technology (AIMT) conducts courses to award Bachelors and Masters Degree programmes in various specializations. It has a well-established manual system to manage almost all the day to day business of an academic institute and is inclined to proceed with automation of all the process. AIMT has a Dean and few Associate and Assistant Deans to assist the Dean in academic matters. It has many departments and each department can offer different programmes. Each department is chaired by a Head of the Department (HoD). Further, each department is identified with a unique ID, department name, and employee_ID of the person who is heading the department. Within a department, each Programme is managed by a Programme Manager (PM), who in turn reports to the HoD.

Each department offers a bunch of courses spread across different programmes which necessitates the need of interaction between the PMs and HoD during allotment of modules to teaching staff. A module to be offered can have multiple sessions and each module is identified by a unique module code, module name and number of credit hours. Each teaching faculty is allocated with a teaching load of minimum of 18 credits. If the module that is offered belong to Master's level, then one credit load is considered to be equal to one and a half credit.

In order to be familiar with the responsibilities of HoDs, AIMT has decided to bring in some changes at the administrative level by introducing one or more Assistant HoDs who can assist the HoD in overall functioning of the department. Existing staff members instead of directly reporting to HoD, will now be directly reporting to one of the Assistant HoDs. After the introduction of Assistant HoDs, the teaching work load of staff who are serving as Assistant HoDs has been reduced to 10 credits and that of the PMs also.

It is to be noted that Dean, Associate/Assistant Dean, HoD, PM, teaching staff such as Professor, Associate Professor, Assistant Professor, Lecturer are all employees and every employee is identified with a unique ID, name, gender, date of birth, designation, department to which he/she belongs, skills of the faculty.

Propose a conceptual model after an in-depth research on AIMT operations and processes. In order to come up with an appropriate design/solution, you must study the requirements, issues and best practices in this problem context. You can make relevant assumptions required to formulate business rules, security, administration and modelling.

Based on the above information execute Task 2, 3, 4 and Task 5. You may have to make additional assumptions to execute the above tasks.

Task 1:

Submit a work proposal, which must include:

- Understanding of deliverables - a detailed description of deliverables.

- General overview of the given tasks - (Part A and Part-B) - initial understanding of solution to all tasks with timeline to complete them and identification of literature resources. (For more clarity, please refer to criteria of evaluating the work proposal given on the last page of this assignment).

Task 2:

Design an Entity Relationship Diagram (ERD) to model the above scenario. Identify the different entities and attributes of each entity. Suggest and justify the choice of relationship and cardinality of the relationship. State the assumptions (if any) made by you to develop the ERD based on your research. Provide detailed analysis and justification for the selection of entities and attributes based on your research.

Task 3:

Derive a set of relational tables from the ER diagram (Task 2), using appropriate choices for the table attributes. List the integrity rules and business rules, which you would recommend to ensure the quality of data. Indicate all necessary key constraints. Critically analyze the constraints and business rules based on your study of the AIMT.

Task 4:

Outline the kinds of anomalies that can arise in the scenario given above by using un-normalized tables. Show how the table created in task 2 could be re-organized into separate tables to avoid anomalies (Decompose the table structures to a set of 3NF tables).

Task 5: As a database administrator identification of specific roles for users, authentication policy, storage management and database recovery are critical. The efficiency and complexity of database administration depends on the identified strategy and tools. Propose and critically review user management, backup/recovery strategy, storage management/techniques formulated for the system discussed in Task 1-3.

Part B

Write a research article in IEEE Format describing the solution to the scenario given in Part-A. The research article can be approximately 2500 words.

Present the research article using a poster presentation covering the following aspects of research:

- Problem specification, importance of research and research questions
- Theoretical framework
- Rigor of literature review
- Methods or empirical analysis techniques;
- Key findings and conclusions;

As a Post Graduate student, you are required to spend time in research and study. Apply the research skills (such as ability to formulate research questions; technical and analytical skills to solve those questions, ability to communicate results) to prepare your article. It is expected that a Post Graduate student demonstrates the research abilities to expand his/her knowledge on latest database technology. Importantly, to achieve the above goal, you are expected to learn with much greater independence and need to do a significant background reading on the chosen topic. The template (Microsoft word file) for the article will be made available on the Moodle soon.

The date, venue and specifications of the poster presentation will be communicated to you. No marks will be awarded if poster presentation is not done.

Guidelines

Follow the guidelines mentioned below for your assignment.

i. Students are expected to do a critical analysis of the tasks and present their analysis by drawing on relevant theoretical concepts. Marks will be awarded based on the ability of students to undertake the task in a logical manner by drawing on appropriate concepts and theoretical frameworks/literatures.

ii. Report should have a Title Page. Title Page should contain the following information.

a. Assignment Name

b. Student name

c. Student ID

iii. It should have Table of Contents.

iv. Use page numbers.

v. Assignment should be typed in your own words using Times New Roman font.

vi. Use Diagrams to explain in detail.

vii. Use suitable notations in your diagrams.

viii. Use appropriate SQL syntax wherever applicable.

ix. Copy paste from the Internet is strictly not acceptable.

x. References should be included in the last page and literature under pinning is needed at the point of explaining the concept.

xi. Attach the evidences (if any).

The purpose of assignment is to do some research work so you can consult books in Library or use internet or computer magazines or any other source. We are obliged to establish assessment criteria and then mark you upon how well (or otherwise) you meet those criteria. In turn, our assessment of you will be scrutinized by the external examiners, so we must be able to defend the marks we award. We will be far more impressed by a student who demonstrates their active participation, interest and understanding of the module subject matter than by a meticulously presented submission.

Verified Expert

The working proposal for 3 pages have been provided for the scenario provided. The Aaliya Institute of Management and Technology is planning to have ERD for the organization for the department use. WHat steps will be taken in each task for Part A and Part B has been discussed in this proposal. An entity relationship model has been created to show the relationship between entities.

Reference no: EM131431455

Questions Cloud

Current account deficit in a country : Explain why observing a current account deficit in a country is not necessarily worrisome. Discuss and compare your answer with another student answer.
What do you think is the role of money as a determinant : A key learning is defined as significant knowledge gained from reading the case. You may choose to explain your key learnings by offering a real-world application, personal insight, your thoughts and opinions about what was stated, how it is handl..
Find the correct mean : The mean salary paid to 1000 workers of an industry was found to be Rs. 130, 40. Later on it was discovered that the salary of the two employees was wrongly entered as Rs. 297 and 165. Their correct salaries were Rs. 197 and 185. Find the correct ..
Calculate skewness using pearsons coefficient of skewness : Calculate the 2nd Decile.- Calculate Skewness using Pearson's Coefficient of Skewness. Tell whether skewness value is positively or negatively skewed.
Evaluate the role of conceptual modeling : Database Systems and Administration - ECM38IS - Evaluate the role of conceptual modeling in the development of database systems and apply the entity-relationship modeling approach to a realistic scenario
Compare the level of capital spending across the two firms : Compare the level of capital spending across the two firms. Point out how the spending was similar and/or different and speculate why the similarities or differences might exist.
Create a layout for a post-event meeting : Create a layout for a post-event meeting highlighting which elements could be improved and which could be omitted from the next edition
What fraction of cans have less than 12.1 ounces : What fraction of cans have less than 12.1 ounces?- To what should you set the mean if you want at most 1 percent of your cans to contain at most 12 ounces?
Calculate the npv for both conveyor belt systems : Hagar Industrial Systems Company (HISC) is trying to decide between two different conveyor belt systems. Calculate the NPV for both conveyor belt systems.

Reviews

len1431455

3/18/2017 12:53:39 AM

This proposal only - I need only 3 pages After i will take the main assignments right question - "V2 Amended PG-DSA-ECM38IS-Spring-17-CW2-PMM.pdf " rest was example only I need Work Proposal: (Turnitin based Submission) only now

len1431455

3/18/2017 12:53:06 AM

Part B: Understanding of the task: Here a research article of about 2000 to 2500 words has to be written on the topic of Automation of the activities of Aaliya Institute of Management and Technology. This requires a thorough literature review and understanding of the state of the art technologies in the chosen topic. The article should be written in IEEE format. The sample IEEE format has been made available on Moodle. After completing the paper, I have to present the findings of the research on a poster, via a poster presentation. The research paper has to be uploaded on Moodle before the deadline of submission. Proposed topic of my research: Institute Management System for Aaliya Institute of Management and Technology References: 1. ABC, DEF, "Incremental Learning", Springer verlag, pp -104-120; 2. XYZ, "Incremental Update of Knowledge in Learning Management Systems, Elsevier, pp-204-209; 3. …

len1431455

3/18/2017 12:52:54 AM

Part A: Understanding of Deliverables: Here a realistic scenario of a relational database system is given. This database system is for the Aaliya Institute of Management and Technology. I have to read the given scenario and perform the following tasks. Task-2 Design an Entity Relationship Diagram (ERD). Here (i) I have to identify the entities (tables) and attributes (columns) of each of the entities. (ii) I have to suggest the different relationships among the identified entities and the cardinality (1:M, M:1, M:N etc.) of the relationships. (iii) If any assumptions are required to complete the ERD, I have to mention all those assumptions. (iv) Finally, I have to justify in my own words regarding the selection of entities and attributes of each entity.

len1431455

3/18/2017 12:52:29 AM

Task 5: Ability to review (a) User management (4M) (b) Backup/recovery strategy (4M) 12 (c) Storage management (4M) Part B: Research article: (Turnitin based Submission) (a) Quality, originality and relevance of research article (5M) 25 (b) Evidence of independent research and critical thinking (3M) (c) Depth of understanding of problem context (3M) (d) Literature review (3M) (e) Concise objectives of research problem (3M) (f) Research methodology (3M); (g) IEEE format (5M) Part B: Poster presentation: (a) Contents: Innovative / Creative (5M) 15 (b) Design: Organization, compliance with documentation, grammar and spelling (5M) (c) Presentation: Presentation skills and Q&A (5M)

len1431455

3/18/2017 12:52:13 AM

Work Proposal: (Turnitin based Submission) A brief explanation of understanding of deliverables for Part A: (2 Marks) Time schedule to carry out tasks for Part-A (2 Marks) Identification of literature for Part B: (2 Mark) Brief understanding of topic for Part-B (2 Marks) Time schedule/Plan for Part B: (2 Marks); 10 Part A: (Turnitin based Submission): Task 2: Extent of clarity in evaluating the role of conceptual modeling in the development of database systems and apply the entity-relationship modeling approach to a realistic scenario 12 (a) 8 entities with attributes including justification (8M) (b) Justification of choice of relationship and cardinalities (4M) Task 3: Ability to apply the essential concepts of relational databases to sample data sets and demonstrate best practice in the development of an appropriate and effective database system. 12 (a) Formation of 8 tables with PKs and FKs (8M) (b) Critical analysis of constraints and business rules (4M) Task 4: (a) Outline the 3 anomalies with appropriate examples(3*3=9M) 14 (b) Normalization and normal forms (5M)

len1431455

3/18/2017 12:51:44 AM

70-100 Shows evidence of extensive investigation of relevant concepts, technologies and issues. Clearly defined argument/ problem definition and source for lucid argumentation. Shows clear evidence of reflective thinking about the issues presents a clear and relevant argument. Substantial originality of innovation and thinking. Work of a very high standard

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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