MIS week 3

?
  • Created by: jmf00632
  • Created on: 03-01-20 11:07
What is an informationn system?
An information system is a set of interrelated components that collect and process data to produce information.
1 of 50
which means......
we need a way to store data
2 of 50
how do we store data effectively and efficiently?
To store data efficiently and effectively in a database we need to model it.
3 of 50
what 3 things consist of modelling data?
entities, attributes and relationships
4 of 50
what is an entity?
o What “things” are the data about? - . its a category of things.
5 of 50
what is an example of entities?
e.g. students name, ? People, objects, events, etc. e.g., employee, product, order
6 of 50
entity is an......
abstract concept
7 of 50
an example of an entity - student
first name surname date of birth address phone no
8 of 50
instance is a....
concrete example of the concept
9 of 50
Abstract
not physical
10 of 50
concrete
physical
11 of 50
FYI
LOOK IN BOOK FOR ABSTRATC/ CONCRETE
12 of 50
What is an attribute?
What are the characteristics of the “things” ? e.g. address
13 of 50
an attriribute is…..
a property of an entity
14 of 50
attributes have....
values from specific instances
15 of 50
an instance may have…..
missing values (null)
16 of 50
there are 5 types of attributes - what are they?
single, composite, simple valued, multi, store versus derived
17 of 50
simple
o A simple attribute cannot be broken down into a smaller component.
18 of 50
composite
A smaller attribute can be divided into smaller components, which represent more basic attributes that have their own meanings
19 of 50
single valued
Having only a single value of each attribute of an entity.
20 of 50
multi valued
• Having the potential to contain more than one value for an attribute. • An entity in relational database cannot have multi-valued attributes. Those attributes must be handled by creating another entity to hold them
21 of 50
store versus derived
• If an attribute can calculated using the value of another attribute, it is called a derived attribute. • The attribute that is used to derive the attribute is called a stored attribute.
22 of 50
business rules intend to convey......
the behaviour and rules of a business
23 of 50
for example in a book store.....
o A customer can purchase many books. o Books can be purchased by many customers. o A book title can have many copies.
24 of 50
another example in terms of uni...
• for example a student needs access to slides, a timetable, • then the lecturer needs access to the students number • from this we can identify the entities and then the attributes- city, post code e,c,t,
25 of 50
• One of the main reasons for creating an ERD is to ....
identify and represent the relationships between entities.
26 of 50
what do entity relationship diagrams (ERD) do for the organisation?
ER diagram depicts the organisation of data with simple graphical symbols
27 of 50
relationships - Entities are related in one way or another - this can through
cardinality relationships or Optionality of relationships
28 of 50
cardianlity relationships.....
o One-to-One Relationships o One-to-Many Relationships o Many-to-Many Relationships
29 of 50
o Many-to-Many Relationships – example
for example a lecture can be presented to may stidents at one time
30 of 50
Optionality of relationships
o Mandatory o Optional
31 of 50
Cardinality of Relationship - husband to wife
one to one
32 of 50
Cardinality of Relationship - student to project
one to many
33 of 50
Cardinality of Relationship - player to team
one to many
34 of 50
Cardinality of Relationship- child to parent
one to one
35 of 50
Cardinality of Relationship - stuent to module
one to many
36 of 50
why do we need ERD (ENTITY REL DIAGRAMS)
Its the first step to build a database
37 of 50
so what is a database?
A bunch of logically related tables (R-tables) with data
38 of 50
why do we need databases?
Each entity corresponds to exactly one table in a database
39 of 50
what are the 6 challenges of managing data?
data redundancy, data inconsistency, data quality, lack of flexibility, poor security, lack of data sharing and availability
40 of 50
data redundancy
the same data stored in many places
41 of 50
data base solution - how can we solve these issues?
logically integrating and linking all the tables
42 of 50
by logically integrating and linking all the tables we achieve,,,, (5)
• Centralised and integrated data storage • Minimal data redundancy • Limited inconsistency • Service of multiple applications • Enforcement of data standards, access rules, integrity constraints and security
43 of 50
what do we need befroe we link the tables?
we need keys
44 of 50
what does a primary key do?
A “primary key” (PK) uniquely identifies a record
45 of 50
an example.......
–e.g., emplID in the Employee table
46 of 50
what is a foreign key?
a foreign key is a primary key in another table - not neccasirily uniwue in this table
47 of 50
what is database normalisation?
Normalisation is the process of eliminating data redundancy and ensuring data integrity
48 of 50
what is data redundancy?
• Duplicate records in a table • Same field in two different tables • Data can be derived from other fields (e.g., total price of an order)
49 of 50
goals of normalisation
oSave space - store each piece of data only once oAvoid inconsistency - changing data once changes it everywhere oMore rapid updates
50 of 50

Other cards in this set

Card 2

Front

which means......

Back

we need a way to store data

Card 3

Front

how do we store data effectively and efficiently?

Back

Preview of the front of card 3

Card 4

Front

what 3 things consist of modelling data?

Back

Preview of the front of card 4

Card 5

Front

what is an entity?

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar Business Management resources:

See all Business Management resources »See all Management information systems resources »