Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

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.

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).

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M92292100
  • Price:- $70

Priced at Now at $70, Verified Solution

Have any Question?


Related Questions in DBMS

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Students will select a situation or problem from their

Students will select a situation or problem from their company as a course project that can be solved using a database system. Using MS Access, or MS SQL Server Express, students will create a relational database model o ...

Instructionsfor decades relational databases remained

Instructions For decades, relational databases remained essentially unchanged; data was segmented into specific chunks for columns, slots, and repositories, also called structured data. However, in this Internet of Thing ...

Assignment question - write and run sql statements to

Assignment Question - Write and run SQL statements to complete the following tasks Part A - DML 1. Locate the record in the vendor table that does not have a value for the attribute V_STATE 2. Find the customers whose ba ...

Question suppose we have two kinds of doctors hospital

Question : Suppose we have two kinds of doctors: hospital doctors and family physicians. In addition to the doctor's id number, name, specialty, and years of experience, we want to record the hospital name for the hospit ...

Case study problem 1 the case study company has experienced

Case Study: Problem 1 The case study company has experienced rapid growth in both the size of its client base and also in the services provided to clients. Unfortunately, the growth in data management policies, procedure ...

Tableau is business intelligence software that helps people

Tableau is business intelligence software that helps people see and understand their data. Fast Analytics Connect and visualize your data in minutes. Tableau is 10 to 100x faster than existing solutions. Ease of Use Anyo ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

This is a starting out with visual basic programming

This is a starting out with visual basic programming problem, meaning its a basic programming nothing advanced. Question: Add a linq statement to the combo box text-changed event to dispaly the city field of the selected ...

Question 1 what isdata-manipulation language dml there are

Question: 1. What isData-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last_ ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As