The Entity Relationship Diagram discussion Part A Scenario: Gulf Institute of Advanced Technology (GIAT) conducts courses to award vocational and certifi

The Entity Relationship Diagram discussion Part A

Scenario:

Don't use plagiarized sources. Get Your Custom Essay on
The Entity Relationship Diagram discussion Part A Scenario: Gulf Institute of Advanced Technology (GIAT) conducts courses to award vocational and certifi
Just from $13/Page
Order Essay

Gulf Institute of Advanced Technology (GIAT) conducts courses to award vocational and certifications

programs in various specializations. Management decided to proceed with automation of all the

process.It has many departments and each department can offer different programs. Each department

is chaired by a Director. 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 there are different

programs, each Programme is managed by a Programme Manager (PM), who in turn reports to the

Director.

Each department offers a bunch of courses spread across different programs which necessitates the

need of interaction between the PMs and Director during allotment of modules to training staff. A

course to be offered can have multiple sessions and each module is identified by a unique course code,

course name and number of credit hours. Each teaching faculty is allocated with a teaching load of

minimum of 18 credits.

Propose a conceptual model after an in-depth research on GIAT 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.

task 1:

Submit a work proposal for this assignment

? 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 institute

Task 4:

As a database administrator evaluate different Database Management system Software for the above

scenario. You are required to prepare a technical and financial feasibility report. You are required to

critically analyse each aspects and suggest the best suitable database management system software for

the above scenario with appropriate justifications.

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.

Task 6:

Prepare a report comprising an executive summary including self-reflections on the industry

guest speaker talk

Part B

Write a research article in IEEE Format on “best practice in the development of an appropriate and effective database system”. 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;

Guidelines

Use reference ,use Harvard style Part A
Scenario:
Gulf Institute of Advanced Technology (GIAT) conducts courses to award vocational and certifications
programs in various specializations. Management decided to proceed with automation of all the
process. It has many departments and each department can offer different programs. Each department
is chaired by a Director. 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 there are different
programs, each Programme is managed by a Programme Manager (PM), who in turn reports to the
Director.
Each department offers a bunch of courses spread across different programs which necessitates the
need of interaction between the PMs and Director during allotment of modules to training staff. A
course to be offered can have multiple sessions and each module is identified by a unique course code,
course name and number of credit hours. Each teaching faculty is allocated with a teaching load of
minimum of 18 credits.
Propose a conceptual model after an in-depth research on GIAT 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.
task 1:
Submit a work proposal for this assignment
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 institute
Task 4:
As a database administrator evaluate different Database Management system Software for the above
scenario. You are required to prepare a technical and financial feasibility report. You are required to
critically analyse each aspects and suggest the best suitable database management system software for
the above scenario with appropriate justifications.
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.
Task 6:
Prepare a report comprising an executive summary including self-reflections on the industry
guest speaker talk
Part B
Write a research article in IEEE Format on “best practice in the development of an appropriate and
effective database system”. 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;
Guidelines
Use reference ,use Harvard style

Purchase answer to see full
attachment

Homework Market Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Unique Features

Custom Papers Means Custom Papers

This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.

Qualified and Experienced Essay Writers

Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Assuarance

We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.

100% Originality & Confidentiality

Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.

Essays

Essay Writing Service

While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.

Admissions

Any Kind of Essay Writing!

Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, homeworkmarketpro.com has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.

Reviews

Quality Check and Editing Support

Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Prices and Discounts

We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.