1. Home
  2. Samples List
  3. View

TECHNICAL-data management and governance correction

Data Management and governance.
1
DATA MANAGEMENT AND GOVERNANCE.
Name of student without capital letters.
Name of class.
Name of the professor.
Name of the school
City and country/state.
Date of submission.
Data Management and governance.
2
ABSTRACT.
This is a report that comprises of class diagrams, explanations of the major design
decisions taken, relational models, table statements and queries. This information belongs to
a company called GreenCress promotions which handles advertising campaigns for its
clients. The report has been written so as to address a problem for the company. The
company would want to make a system for keeping track of campaigns since at the moment
all the documents are held on paper. The paper way of storing information worked great
when there were a small number of clients, but now that the number of clients and staff has
grown, it is hard to rely on paper documentation. It was noted that the paper documentation
was not keeping accurate track of a campaign and this is making the company loose business
through poor management of campaigns. The study was undertaken by observation of how
things were being run in the company and by analysing the documents and number of lost
customers due to mix-ups. The significance of the findings is that it enabled the company
know what loopholes they had and try to fix them. The company has therefore decided that
they need a database system to keep track of its campaigns.
Data Management and governance.
3
The following information is a class diagram that will capture the data, links
and constraints capable of supporting the requirements outlined in the question.
1
Two members act as
contacts for campaign ( )
STAFF
Pay for advert ( )
CLIENTS
PRODUCT
CAMPAIGN
ADVERT
ADVERTISING LOCATION SPACE
+Staff id: int
+Name: char
+Telephone no: int
-Salary: int
-Fax no: int
+Email: string
+Role: char
Campaign code: string
Campaign name: char
Campaign manager: char
Campaign team: char
Start time: string
End time: string
Duration: string
Purpose: char
Room used: string
Staff attending: char
Premise held: char
Name: char
Charged: int
Position: char
Email: string
Telephone number: int
Pay for advert ()
Summary sheet: char
Campaign no: string
Start time: string
End time: string
Advert code: string
Advert type: char
Description of content: char
Description of intended audience: char
Intended size: string
Range of components: char
Advert no: string
Component type: string
Completion date: date
Completion statement: char
Type: char
Unique code: string
Record card: string
Locations: string
Roll out day: date
Roll out time: string
1
Two members act as
contacts for campaign ( )
STAFF
Pay for advert ( )
CLIENTS
PRODUCT
CAMPAIGN
ADVERT
ADVERTISING LOCATION SPACE
Summary sheet: char
Campaign no: string
Start time: string
End time: string
1
Two members act as
contacts for campaign ( )
STAFF
Pay for advert ( )
CLIENTS
PRODUCT
CAMPAIGN
ADVERT
ADVERTISING LOCATION SPACE
Campaign no: string
Start date: string
End date: string
Campaign code
name:char
Company: char
Product: char
Data Management and governance.
4
A class diagram is a diagram that contains classes which are explained by their
attributes and operations. These structures enable one to know all the requirements of their
system before the create it. The major design decisions taken enable one to be able to see a
structural view of the systems that will be created. This is by creating all the classes needed and
populating them with all the necessary information that they should have. The diagram is in the
form of a hierarchy where all the classes are interconnected and range from the first to the last
step respectively. General priorities decisions were based on the following criteria; fulfilling
use-case requirements which are a crucial part of the class diagram, simplicity of the diagram to
be understood by the people who will need to use it, able to work with file transfer as well as
offline editing and ease of implementation. The design is able to show all the components and
their links and information connected to them. The design is easily interpretable and anyone is
able to understand it. People will be able to do a lot of things offline hence making it easier for
them to be able to deal with information weather the internet is there or not. For example, one
might need to add on crucial information to the system yet the internet is cut off. In this case, if
there are no ways to put this information offline without the presence of the internet, then this
might lead to loss of data since the human brain can forget. It is easier to deal with information
one can be able to implement the design without having to figure out a lot about what the
system entails since it has already been stated clearly in the design. The diagram helps
developers and other team members in the making of the system since it makes it easier for one
to see all the elements. Class diagrams are a crucial part of the development of any system
development in that they are needed before the system is created so as to give a view of what
the system should be like so as to avoid any confusions and forgetting of vital information in
Data Management and governance.
5
the system. This diagrams are very simple and fast to read hence saving on time so as to do
other crucial things.
The major shape that is used in the classes is rectangle which is partitioned into three
partitions. The diagram is designed in a way that it shows the relationships between classes,
objects, operations and also the attributes. This kind of format is clear since all important
information is situated in its layer which makes it neat and organized.
This diagram is a type of static structure diagram. It is created in that it describes the
structure of a system. This is done by the showing of the systems classes and what it contains.
The classes have their attributes, operations and relationships. A class diagram is subdivided
into three. First is where the name of the class is, the second is the attributes of the class and
lastly the class operations. A class diagrams name is the element that shows the name of the
class for example in the case of the above diagram; a good example can be the staff. The first
class in the diagram is called staff. The Staff is a name given the people who work in the
company so as to ensure that all the promotions they get are done according to how the
clients want them to. Without them there are no functions that can be executed. The classes in
my diagrams include active classes which are the ones that control the flow of all the
activities that are happening. A good example is the staff. They are one of the crucial
components needed so that the activities will be performed.
The class attributes include more information that can describe the class. This is
more information about a class that explains all about it so that it can be easier to recognize
the difference between one class and another one. This is possible because the attributes of
something enable one to locate a particular class without having to use a lot of effort. In case
there were no attributes stated, then it would be really hard to know more about a class. For
example if there was no attribute of name on the class staff, people would find it hard to
Data Management and governance.
6
figure out how to communicate since the name of a person is what identifies them. For
example in the diagrams above we can see that the staff class contains attributes such as; the
staff identification number which is used to differentiate the workers. It plays a great role
since people might have the same name but it can be easier to refer to them with their
identification number for example d1023 which is never the same, the name of the staff
member for example Maxwel Daniel, the telephone number of the staff for example
0729262727, the salary of the staff for example 30000, the fax number of the staff for
example 79780 and the email of the staff for example [email protected]. This
attributes are able to explain more about the class so that the person dealing with the same
will find their work easier.
The class operations are what the class can do. For example the campaign manager
who is under the staff can be able to form a campaign team. By being able to know exactly
what operations a class is supposed to do, it is easier to allocate more jobs without confusion.
Another example is that of the clients where they are able to pay for the adverts that they
want to be aired. The same ones can specify how they want their adverts to look and decide
to collaborate with the staff to ensure that it is done they want it to be. In case there was no
specification of the operations of a particular class, it will be hard to know the roles of the
respective classes.
The diagrams include relationships for example there is a presence of simple
association where two classes can be linked together so as to show that they are related in
some way. This therefore enables one to know that the two elements are connected to each
other for example the campaigns and adverts. It is easier to associate the two on the diagram
so that it would be easier to create a great system that is better understood. There are some of
the classes that are dependent on others in that when they change anything in the class that
Data Management and governance.
7
they are dependent on information also changes in them. There are associations which are in
terms of arrows or lines. These are the lines that link the classes. For example; we can view
that the staff and clients are joined together by the use of this association annotations
represented by a line with an arrow.
There is the presence of visibility of class attributes and operations. There are around
four types of visibility which include the protected, private, public and package. The + sign
represents the public attributes or operations which can be viewed and known by anyone. For
example the name of staff since the name of a person is not supposed to be a secret since that
is what they are recognized with. The – sign represents private attributes or operations which
are private in that not everyone can view them. A good example is the amount of money a
person is paid. Some people do not like it if people know how much they are paid since it can
bring about a lot of controversial thinking and unnecessary gossiping. The # sign represents
the protected attributes or operations which cannot be seen by everyone since it is protected
and only used when authorized. For example a person’s medical status cannot be shared with
anyone since in case it leaks to the public one might end up suing another. The ~ sign
represents package attributes or operations.
There is the presence of multiplicity. This is what shows how many objects in the
class diagram will be part of a relationship. There are several types of multiplicity; 1 which
means exactly only one, 0..1 which refers to zero or one,1..* which refers to one or more, 0..*
or* which means many,1..*, 0..1, 3..4 which denotes a complex relationship and lastly 3..4 or
6 which represents the exact number.
The diagram below is a relational model for the class diagram that has been created
above as explained on the first paragraph.
Data Management and governance.
8
Staff (staff id, name, telephone no, salary, fax no, email, role)
Clients (name, charged, position, email address, telephone)
Product (campaign code, campaign name, campaign manager, campaign team,)
Campaign (summary sheet, campaign number, start time, end time)
Meeting (date, start time, end time, duration, purpose, room used, staff attending,
premise held)
Advert (adv code, adv type, content description, audience description, intended size,
components range, adv no, component type)
Advertising location space (type, unique code, record card, locations, roll out day,
roll out time)
Staff
Staff
id
Name
Telephone
no
Salary
Fax no
Email
Role
D33
Issac
maya
0799992732
40000
609887
[email protected]
Graphics
designer
D90
Mirriam
Diana
0729373583
30000
876555
[email protected]
Account
manager
D02
Sant
mari
0713736820
90000
890976
[email protected]
Campaign
manager
Data Management and governance.
9
Clients
Name
Charged
Email
Telephone no
Lugard tie
20000
[email protected]
0798765456
Miamo Dianne
30000
[email protected]
0726363735
Sandra cate
5000
[email protected]
0725342624
Frank tim
4500
[email protected]
0736243262
Damaris
freeman
76000
[email protected]
0735264352
Product
Campaign
code
Campaign
name
Campaign
manager
Campaign team
C111
wiggles
Sant mari
Daniel wine , sentinel miles, dan
ben, sia getry, simeon be, lara mast,
don moen, lugard tie, malcom raterg
C330
imara
Sant mari
Simeon be, lara mast, don moen, sia
getry, lugard tie, Daniel wine,
sentinel miles, malcom raterg, dan
ben
C002
diani
William dan
Simeon be, lara mast, don moen, sia
getry, david alex, Daniel wine, dan
ben, sentinel miles, lugard tie
Data Management and governance.
10
C398
samora
Sant mari
Daniel wine , sentinel miles, dan
ben, sia getry, lugard tie, malcom
raterg, lara mast, susan miller, jane
lee
C847
dangle
William dan
Simeon be, lara mast, don moen,
yusuf Daniel, Daniel wine, susan
miller, lugard tie, dan ben
Campaign
Campaign
code name
Campaign no
product
company
Start date
End date
froggies
C120
Training
videos
PBMY
associates
3rd jan
2017
15
th
april
2017
mirage
C122
Training
dances
PBMY
associates
4th jan 2017
10
th
april
2017
dubies
C140
Cooking
food
PBMY
associates
10th jan
2017
11
th
april
2017
salts
C220
Training
singers
PBMY
associates
1
st
jan 2017
30
th
april
2017
Meeting
Date
Start
time
End time
Duration
Purpose
Room
used
Staff attending
Premise
held
Data Management and governance.
11
2/3/2018
10:00am
11:00am
1hour
Collaboration
with tv
station
Mt 06
Michael alex,Sant
mari,
Wesley Gerry Issac
maya, Mirriam
Diana, Daniel dave,
sia Getry, , martin
wells, winny datrs,
wayne bee, Diana
miles,Wilson trump
Greencress
3/3/2018
11:00am
1:00pm
2hours
Buying of
equipment
Mt 10
Issac maya,
Mirriam Diana,
santa maria, Edwin
galo, sia Getry’
malon muty, seth
bromy, wayne tost,
winny darts, wayne
datr
Greencress
5/4/2018
9:00am
11:00am
2hours
Buying of
equipment
Mt 9
Issac maya,
Mirriam Diana,
Michael alex,Sant
mari, seth bolt
Wesley Gerry Issac
maya, Mirriam
Diana. Sia Getry,
malon manny
Greencress
12/4/2018
10:00am
12:00am
2hours
Buying of
equipment.
Mt 6
Issac maya,
Mirriam Diana,
Michael alex,Sant
mari, sia
Getry,winny datrs,
wayne bee,Diana
miles, Wilson
trump,
Greencress
21/4/2018
12:00pm
1:00am
1hours
Building of
new rooms
lounge
Issac maya,
Mirriam Diana,
Michael alex,Sant
mari, Wesley Gerry
Issac maya,
Mirriam Diana, sia
Getry
Jalbi hotel
Advert
Data Management and governance.
12
Adv
ert
cod
e
Adv
type
Conten
t
Descrip
tion
Audien
ce
Descrip
tion
Intend
ed size
Range
of
compon
ents
AdV
no
Compo
nent
type
Compl
etion
date
Compl
etion
stateme
nt
A11
Photog
raph
Selling
of
dresses
Wome
n and
babies
A4
Picture,
caligrap
hy
A02
L1
3/3/201
8
Compl
ete
A22
Mp3
Concer
t
invitati
on
The
youth
10min
utes
Songs,
talks
A67
L2
4/3/201
8
Compl
ete
A10
Photog
raph
Selling
of soap
Family
househ
olds
A4
Pictures
.
Caligra
phy
A39
L1
4/4/201
8
Not
comple
te
Advertising location space
Type
Unique
code
Record
card
Locations
Roll out day
Roll out time
Clip, mp3
D003
R66
Television, radio
3/3/2018
6:30 am
Mp3
D908
R20
Radio
4/6/2018
7:50pm
Mp3,
photograph
D789
R55
Radio, magazine
10/6/208
10:45am
Data Management and governance.
13
The data will be implemented on the set of relational tables created in the
relational models using oracle and the tables populated with relevant data. In the
report, I will include my create table statements and a screenshot of sample data.
Below are queries to demonstrate that my database meets the data requirements of the
system. A screenshot of the query output will be included in the report.
create table CLIENTS (
Name varchar2(255) not null,
Charged number,
Position varchar2(255) not null,
Email varchar2(255) not null,
Telephone number not null,
id number constraint clients_pk primary key
);
Data Management and governance.
14
Figure 1: Client Table
create table PRODUCT (
id number not null constraint product_pk primary key,
Campaign_code varchar2(255) not null,
Campaign_name varchar2(255) not null,
Campaign_manager varchar2(255) not null,
Campaign_team varchar2(255) not null
);
Figure 2: Product Table
Data Management and governance.
15
create table Campaign (
id number not null constraint campaign _pk primary key,
summary_sheet varchar2(255) not null,
campaign_number varchar2(255) not null,
start_time date not null,
end_time date not null
);
create table Meeting (
date date not null,
start_time timestamp not null,
end_time timestamp not null,
duration number not null,
purpose varchar2(255) not null,
room varchar2(255) not null,
staff_attending varchar2(255) not null,
premise varchar2(255) not null,
id number not null constraint meeting_pk primary key
);
create table Advertisement (
id number not null constraint advertisement _pk primary key,
advert_code varchar2(255) not null,
advert_type varchar2(255) not null,
Data Management and governance.
16
desc_content varchar2(255) not null,
desc_audience varchar2(255) not null,
Intended_size varchar2(255) not null,
range_components varchar2(255) not null,
advert_no varchar2(255) not null,
Component_type varchar2(255) not null,
Completion_date date not null,
Completion_statement varchar2(255) not null
);
create table Ad_location (
id number not null constraint ad_location_pk primary key,
type varchar2(255) not null,
unique_code varchar2(255) not null,
record varchar2(255) not null,
location varchar2(255) not null,
rollout_day date not null,
rollout_time timestamp not null
);
Data Management and governance.
17
INSERT INTO Product
VALUES (1, 'C111', 'wigglesSant mari', 'Daniel wine', 'sentinel miles');
In conclusion to my report, it is evident that before making a system it is
easier and recommendable to create a class diagram before the creation of a system.
Drawing of a class diagram is not hard since all a person needs to know are the
connections, data and way of distinguishing what should be added on what partition
of the class. This therefore means that class diagrams are convenient due to the fact
that anyone can be able to interpret them. I would that before making a system one
should consider making a class diagram first so as to make their work easier. Another
thing I would recommend is that all those who want to create class diagrams should
make sure that they include all the information that is needed so that there will no
omission of data in the system.
Data Management and governance.
18
Works Cited
Murdaca, C.: An Object-Relational Compiler, World Congress on Computer Science and Information
Engineering, IEEE (2009).
Ambler, S.W.: Mapping Objects to relational Databases, Ambysoft Inc. (1997).
Keller, W : Mapping Objects to tables, A pattern language, Proceedings EuroPlop (1997).
Connolly, T., Begg, C.: Database System A Practical Approach to Design, Implementation, and
Management, Addison Wesley (2010).
Khoussainova, N., Kwon, Y., Balazinska, M., Suciu, M.: Snipsuggest: A context-aware sql
autocomplete system. Balazinska (2011).

Place new order. It's free, fast and safe

-+
550 words
Total price: $ 15.00

Our customers say

Customer Avatar
Jeff Curtis
USA, Student

"I'm fully satisfied with the essay I've just received. When I read it, I felt like it was exactly what I wanted to say, but couldn’t find the necessary words. Thank you!"

Customer Avatar
Ian McGregor
UK, Student

"I don’t know what I would do without your assistance! With your help, I met my deadline just in time and the work was very professional. I will be back in several days with another assignment!"

Customer Avatar
Shannon Williams
Canada, Student

"It was the perfect experience! I enjoyed working with my writer, he delivered my work on time and followed all the guidelines about the referencing and contents."

  • 5-paragraph Essay
  • Admission Essay
  • Annotated Bibliography
  • Argumentative Essay
  • Article Review
  • Assignment
  • Biography
  • Book/Movie Review
  • Business Plan
  • Case Study
  • Cause and Effect Essay
  • Classification Essay
  • Comparison Essay
  • Coursework
  • Creative Writing
  • Critical Thinking/Review
  • Deductive Essay
  • Definition Essay
  • Essay (Any Type)
  • Exploratory Essay
  • Expository Essay
  • Informal Essay
  • Literature Essay
  • Multiple Choice Question
  • Narrative Essay
  • Personal Essay
  • Persuasive Essay
  • Powerpoint Presentation
  • Reflective Writing
  • Research Essay
  • Response Essay
  • Scholarship Essay
  • Term Paper
We use cookies to provide you with the best possible experience. By using this website you are accepting the use of cookies mentioned in our Privacy Policy.