Information Systems Individual Assignment - Damelin College - Assignment

716 words - 3 pages

This question paper consists of 4 pages including the cover page.
Read the following instructions CAREFULLY:
1. Your assignment should be typed – Arial font 12; 1.5 spacing; Justified (ctrl + J))
2. Use the Harvard method of referencing.
3. You must consult at least three different sources or preferably journals for adequate
4. Assignments must be presented in the correct format. Marks will be awarded in conjunction
with contents for overall presentation as per marking rubric.
5. Ensure that your name and the name of your campus are clearly indicated on the cover page of
your assignment.
6. Keep photocopies of all assignments handed in.
7. Plagiarism and copying of assignments will result in the default mark 0% being awarded. This
is also a punishable offence, which will lead to a disciplinary action.
8. It is in your own interest to present your work neatly.
I, the undersigned declare that:
 I understand what plagiarism is and are aware of the Damelin’s policy in this regard.
 The work hereby submitted is my original work, gathered and utilised to fulfil the requirements of
this assignment except for source material explicitly acknowledged.
 I have not used work previously produced by another student or any other persons to hand in as
my own.
 I have not allowed, and will not allow, anyone to copy my work with the intention of passing it
off as their own work.
Signature of Student Date
QUESTION 1 (28 marks)
1.1 Since a DBMS is collection of programs that manages the database structure and
controls access to the data stored in the database. Discuss six (6) advantages of
1.2 Discuss eight (8) types of databases (16)
QUESTION 2 (17 marks)
2.1 Discuss four (4) building blocks of every data models (8)
2.2 Discuss three (3) types of relationship and provide example for each relationship. (9)
QUESTION 3 (36 Marks)
Student Database System
You are required to design a student database system that is capable to manage a college.
The database must be capable of performing the following activities. A student should be able
to view the marks of the subjects that he/she is registered for. The student should be able to
view the classes that he/she is attending and the subject the he/she is going to attend
including the group. The lecturer should be able to view the subject that he is going to teach
including the group that is going to attend that class. When designing the database, you must
keep this information in mind:
 A student must be able to access marks for one or many subjects that he/she is
registered for (Example: a student can access marks for Programming 3A, Software
engineering 1A, Project management, Information System 3A, etc.).
 A registered student belongs to a certain group, but he can’t belong to more than one
group at the same time (Example: A registered student can belong to Diploma in IT
3rd year students or Diploma in IT 2nd year students or Diploma in Accounting 3rd
year, etc.)
 A lecturer teaches one or many subjects (Example: A Lecturer can teach,
Programming 1A, Programming 3A, Programming 2A)
 A Lecturer can teach one or many groups, but not at the same time (Example: A
Lecture can teach IT 3rd year students, IT 2nd year students, etc.).
 A subject contains one or many marks (Example: Programming 3A can contain
marks for individual assignment, group assignment, DP test, etc.)
3.1 From the study case above, write down all the business rules that you can identify. (12)
3.2 From the business rules that you have identified in Question 3.1, Draw a UML diagrams
for them.
QUESTION 4 (19 Marks)
4.1 Using the case study in Question 3 above. Draw an ERD diagram, your ERD
diagram must include the following components:
 Include attributes in your entities,
 Clearly show your primary keys and foreign key in your entity diagram.
 Show your relationships (Multiplicities)

More like Information Systems Individual Assignment - Damelin College - Assignment

Final Exam Assignment Information Technology - University Of Potomac - Assignment

1651 words - 7 pages ... a vital issue. Encryption has come up as an answer and assumes an imperative part in data security framework. Numerous methods are expected to ensure the common information. The present work center around cryptography to anchor the information while transmitting in the systems, by utilizing decoding system the collector can see the first information this paper actualized three encode systems like AES, DES and RSA calculations and looked at their ...

HHS Privacy Policy: Personal Health Information - Health Science- UWO - Assignment

1357 words - 6 pages ... What is meant by the term “personal health information”? In general terms, personal health information is any information in oral or recorded form that can be used to identify a specific individual. What information does the hospital collect? HHS collects both personal health information such as your name, date of birth, address, phone number and Health Card Number. Information relating to previous health issues, treatment plans and history of ...

Dylan Santoso Enzyme Assignment - Hills College - Assignment

1064 words - 5 pages ... Paragraph 1 background information Paragraph 2,3,4 Analyse another anti-smoking text INTRODUCTION The Effectiveness of Anti-Smoking Texts There are millions of underage teenagers that smoke in this world. Smokers think that smoking is cool, enjoyable and it helps them to boost their mood; yet smoking fatally harms their organs and body. Teenagers these days get many diseases because they choose to stay and hang out, and with bad society instead ...

Advantages And Disadvantages Of Virtual Teams - HRM 742 - Individual Assignment 2

1571 words - 7 pages ... 2 Debbie Kolchew Individual Assignment #2 February 25, 2019 Identify and explain the advantages and disadvantages of virtual teams. Outline the factors required for virtual teams to be successful. Advantages of Virtual Teams Cost savings - The biggest advantage of virtual team enjoyed by an organization is the associated cost savings. The organization can do away with huge expenses on real estate, office spaces, utilities bills such as gas ...

Use And Develop Systems That Promote Communication - Leadership In Health And Social Care Level 5 - Assignment

1857 words - 8 pages ... Leadership in health and social care, level 5. Unit 1 Assignment: Use and develop systems that promote communication. 1.1 Review the range of groups and individuals whose communication needs must be addressed in own job role. I work directly with service users, families and relatives, employer and colleagues. I work indirectly with other health care professionals and external agencies to provide the care that service user’s needs. Therefore, a ...

Research Information Assessment - Cibt - Assignment

1389 words - 6 pages ... Analyse and present research information Table of Contents Introduction 1 Research objectives 1 Legislation 1 Company policy and procedures 1 Online sources 1 Provide evidence for the investigation 1 Gathered information for problem analysis, interpretation and dissemination 1 Used a range of business technology to gather, collate and analyse information 1 Modified, maintained or stored the information that is relevant to the 1 Introduction ...

Article Summary Medical Geography - Cuyahoga Community College Physical Geography - Assignment

715 words - 3 pages ... Aaron Jenkins ESCI 1310 Professor Davis CRN 50424 June 8, 2019 Medical Geography: 3 Article Summary This assignment consisted of three articles all concerning the sub-discipline of Medical geography. The first of the three I will talk about is from the web page ThoughtCo.; and is entitled Medical Geography A History and Overview of Medical Geography, by Amanda Briney. The title provides an accurate claim of what this article contains and was a ...

Case Study Report On Information Management Systems - Martni College IMS100 - Case Study Report

2088 words - 9 pages Free ... Case Study Report IMS100 INformation management Systems Assessment 3 Student Name: Introduction ABC Timber and Hardware are a small chain of hardware stores operating out of 12 branches across the state. The current Information Management System (IMS) requires expert personnel to extract relevant information from the accounting system and therefore requires a longer period of time to progress down the supply chain. As a result, sales ...

Information Management Business Opportunities - Univeersity - Assignment

2576 words - 11 pages ... PAGE Using writing techniques Khanya Mangoale 201373025 Information Management 1A Research Report 2 Due date: 22 April 2017 Lecturer: Mr. J Arthur Table of contents Page 1. Introduction 3 2. Business opportunity 3 3. Business Systems thinking 4 4. Architecture planning 5 5. IT Architecture 5 6. Service delivery 8 7. Vendor Development and Contract monitoring 9 8. People 9 9. Relationship building 9 10. Leadership 9 11. Contract ...

Tax Treatment Of Charitable Contributions - Wcu/individual Taxation - Assignment

404 words - 2 pages Free ... Advanced Individual Taxation Noncash Charitable Contributions and Foundations Worth 15 points Look at Romney’s 2011 Form 8283 1. What amount of deduction did Romney take for noncash charitable contributions? $920,573_____ 2. What type of organization is the Tyler Charitable Foundation? (has now become Romney Foundation for Children) · public charity, private operating foundation or private nonoperating foundation 3. Is the deduction valued at ...

Diverse Learners : In This Assignment The Researcher Will Look At Different Trends And Issues - American College Of Education - Assignment

1730 words - 7 pages ... Running head: ED5123 MODULE 3 APPLICATION 1 ED5123 MODULE 3 APPLICATION 2 ED 5123 Module 3 Application Diverse Learners Yaneek Minott American College of Education “Diversity in education encompasses students from many races, genders, and socioeconomic backgrounds; students who speak a variety of languages and students from many cultures” (Ruggs & Hebl, 2012 p.1). The teacher in the classroom must be knowledgeable enough to meet these diverse ...

Organizational Systems And Quality Leadership Task 1 - WGU Organizational Systems And Quality Leadership Task 1 - Assignment

829 words - 4 pages ... Running head: Organizational Systems Task 1 1 Organizational Systems and Quality Leadership Task 1 Cecilia Koutoubi Western Governors University Organizational Systems and Quality Leadership Task 1 A. Understanding of Nursing Quality Indicators A.In 1998, American Nurses Association established a database program where healthcare organizations can input and measure their efficacity and safety in nursing care. This is called National ...

Advisory Reflection Spring Semester - Saint Marys College First Year Advisory Council - Assignment

1245 words - 5 pages ... . So, I made the choice to come here, and I don’t regret it. I believe that the community dynamic at Saint Mary’s has really helped me develop as an individual. Yes, we are a small school but that has made everything so much easier. I enjoy being able to email my teachers and have them respond immediately. I love being a person with a name and not just an ID number on an assignment. Academically, I’ve become stronger than I was. First semester I did ...

WANNACRY Virus : The Bad And The Ugly - Cuny City College - Assignment

964 words - 4 pages ... security for personal and confidential information of an individual .As human beings, overtime we become more advanced in technology where in various ways benefit mankind. Also as human beings, in today’s in this modern world, where measures have been taken to improve the security level in the distributed systems hackers have found a way to crack into systems and take away information. Specifically I will discuss a virus called the WANNACRY virus ...

Practise Of Public Relations Poe 2018 - Varsity College Cape Town - Assignment

3457 words - 14 pages ... SIYABONGA NGXOWENI prpr assignment 15004819 DPRE 1 4/20/2015 I, [SIYABONGA NGXOWENI] hereby declare that I did not plagiarise any content of this assignment and that this is my own work. Signed: ____________________________________ Name of Lecturer Page 13 of 14 Table of Contents 1: ………………………………………..evaluating the importance of writing in P.R 2: ………………………………………..creative and conceptual ...