Free Essay

Untitled

In:

Submitted By PeterParker1996
Words 1011
Pages 5
De evolutie van verkoop tot online marketing in notedop.

“verkoop wat je produceert” 1950

“verkoop waarde markt behoefte aan heeft” marketing 1980

“wordt gevonden door je doelgroep” online marketing 2010

wat is marketing?

Een definitie van marketing: het optimaal en doelgericht afstemmen van de bedrijfsactiviteiten op een gesignaleerde marktbehoefte, met winstmaximalisatie als eindstreven.

N.B. Marketing is een continu proces, één van de afdelingen binnen een bedrijf en onmisbaar in de huidige markt en maatschappij.

Bedrijfsactiviteiten → focus en afstemming → gesignaleerde marktbehoefte.

De term online marketing

online marketing is het toepassen van marketing met internet als hulpmiddel.

Online marketing wordt ook wel internet marketing genoemd.

Elementen van online marketing

online adverteren aan hoge positie door te betalen per klik email marketing aansprekende nieuwsbrieven met een link social media activiteiten gebruik van bijv. Facebook, eventueel met link zoekmachine marketing optimaliseren van de webpagina's

zoekmachineoptimalisatie- is de basis en vormt de strategie!

Optimalisatie van de website is noodzakelijk

te realiseren door 'zoekmachineoptimalisatie-'

in het engels: Search engine optimization (SEO)

Samengevat

bij het volgen van online marketing ontdek je waarom en hoe een website wordt afgestemd op je doelgroepen, nl:

belangrijk voor de vindbaarheid via de zoekmachines (zoekmachines kijken naar de gebruiksvriendelijkheid en correctieheid , dit beïnvloedt de positie) belangrijk voor de aantrekkingskracht naar de klant ( het gaat erom dat een klant 'klikt' en blijft 'plakken' aan de website, ofwel gebruiksvriendelijk)

bovendien vindbaarheid regel je niet achteraf ( je houdt hier rekening mee tijdens het ontwerp van je site, bij een bestaande site doe je aanpassing.

Vindbaarheid + inhoud website = succesbepalend

lesmodule 2.

zoekwoord of zoekterm

een zoekwoord is een woord die jouw product of dienst kenmerkt. Het is het woord dat de internetgebruiker intypt in de zoekmachine.

Hoe kan ik worden gevonden?

aantrekken van potentiële klanten naar je website email marketing, social media “pull”

leverancier → zoekmachine → klant

SEO nader beschouwd.

Seo is een afkorting van 'Search Engine Optimization' – Zoekmachineoptimalisatie-
SEO is een vorm van online marketing
SEO is een manier om goed gevonden te worden in zoekmachines, bijv. in google

Wanneer en Waarom SEO

als je de omzet wilt verhogen als je de merkbekendheid wilt verhogen als je gebruikservaring wilt verbeteren. (user experience) als je wilt worden gevonden op zoekwoorden als je social media effectief wilt inzetten als de website een kritische succesfactor is of gaat worden.

De missie van zoekmachine Google en de kern van SEO

google kijkt naar de opbouw van een website en de gebruiksvriendelijkheid ervan.

Ten aanzien van de opbouw:

logische en gebruiksvriendelijke structuur van de website en gebruikte teksten optimaal gebruik van de zoekwoorden belangrijke externe links naar je website

de basis SEO voor google is gebaseerd op het volgende:

'de zoekresultaten moeten maximaal relevant en belangrijk zijn, in relatie tot de zoekopdracht

definites:
“relevantie:
= maximale aansluiting tussen zoekwoorden en te presenteren pagina

belangrijkheid
= een goede reputatie, de webpagina is populair.

De missie van Google en de kern van SEO

“de kern van SEO is om ervoor te zorgen dat jouw webpagina maximaal relevant en belangrijk is voor een zoekopdracht

Ca. 200 factoren spelen een rol

maar ga uit van de 80/20 regel!
(het gaat erom dat je niet met alle factoren rekening kunt en gaat houden > selchts enkele zijn meetbaar en beïnvloedbaar.

On page factoren > betreft eigen pagina

off page factoren > buiten je pagina vb. domeinnaam, domeinleeftijd.

De zoekmachine

de functies van een zoekmachine? vinden en presenteren van een website indexeren en opslaan van data uit.

Hoe doet de zoekmachine dat?

Afspeuren van internet naar nieuwe en gewijzigde pagina's het zogenaamde 'crawling'

de crawler leest de zogeheten HTML taal van de website

de crawler slaat een deel van de data van de website op in een database.

De zoekmachine – een dubbele functie

het vinden en presenteren van webpagina's die aansluiten bij de zoekopdracht het afspeuren van internet naar nieuwe en gewijzigde webpagina's 'crawling' de crawler leest de HTML code op de server.

Data bases worden gevuld met zoekwoorden en signalen.

HTML is een code/opmaaktaal die wordt gebruikt voor het bouwen van een website.

Samengevat

zoekwoord een van de meest belangrijke factoren vindbaarheid en actie klantvan pull en push
SEOals de website een kritische succesfactor is missie van Googlebelangrijk en relevantie is de basis de zoekmachinepresentatie

Hoe richt ik mijn website in?

informeren overtuigen aanzetten tot aankoop contact laten opnemen

denk na over call to action

ken jij je doelgroep?

Geslacht leeftijd geografisch taal interesse

de basis

zorg voor een lichte witte achtergrond maak de website aantrekkelijk door aansprekende foto's gebruik van scherpe foto's niet teveel tekst, maar ook niet te weinig ca. 350 woorden maximaal 3 click naar call to action.

Eigen website

zakelijk product dienst advies vereniging webwinkel blog foto album

Domeinnaam bedenken

opbouw lesmodule 3

de search engine results page SERP en de onderdelen.

Betaalde advertenties SEA ( search engine advertisments

SERP results

Title Tag
Url pagina basis snippet

title tag door gebruiker per pagina bepaald in het CMS systeem url pagina is de plek op de server war de webpagina zich bevindt de gebruiker bepaalt de URL (gebruikt hiervoor ook zoekwoorden) basis snippet google haalt deze informatie zelf uit de description tag of haalt de informatie uit een externe websitecatalogus

lesmodule 4

de leerdoelen van deze lesmodule:

onderdelen van een webpagina

xml en html sitemap

xml sitemap (extensible markup language)

voor de zoekmachine makkelijke indexering aanmaken en uploaden via webmastertools handmatig aan te passen geen garantie voor indexering uploaden bij elke wijziging

html sitemap

voor je bezoekers

CSS voor de grafische opmaak

naast de HTML opmaaktaal wordt er ook gebruik gemaakt van CSS bestanden
CSS is de afkorting van Cascading Style Sheet

in één of meerdere CSS wordt de grafische elementen van de webpagina's vastgelegd

het voordeel is dat de HTML codetaal hierdoor beperkt blijft in complexiteit en webpagina's sneller worden getoond door de browser

CSS

HTML bepaald de structuur
CSS is de taal voor het presenteren en vormgeven van HTML documenten
CSS bepaalt de presentatie

samengevat

webpagina opgebouwd uit verschillende onderdelen, elk onderdeel heeft zijn functie sitemap HTML sitemap voor duidelijkheid aan de gebruiker XML sitemap voor indexatiedoeleinden

GML
Suits, accessoires, Suits supply,

tools.seobook.com/general/keyword-density/

ubersuggest.org/

Similar Documents

Free Essay

Untitled

...Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document hello Untitled document ...

Words: 258 - Pages: 2

Premium Essay

Untitled

...MEMO To : Mario Comino, Managing Director From : Sofi Rosman, Marketing Manager Date : 14 January Subject : Solution for Caferoma’s Problems For your consideration, we held an internal meeting on January 10 regarding Caferoma’s problems. Among the problems are due to brand loyalty, price and copied product. Therefore, below are the suggestion that have been agreed in the meeting last week. Repositioning the product Segment - variety the target market, make it suitable for different necessity. Taste - add new flavors such as mocha, vanilla, espresso, etc. - Packaging - design a new packaging which more attractive, fresh look, simple and classic. Pricing Reduce the price by, say, 20% to 30% to make it more competitive. Hence, it represents affordable brand. Advertising Hire a prominence individual to be brand ambassador. Give trial version at hypermarkets as a promotion for new flavors suggested above. Run a new advertising campaign that create awareness of brand’s new look and flavors. Multiple Brand Give minor product changes, under different brand names at lower prices. Own label products Makes an agreement with hypermarkets to sell Caferoma’s coffee under their own labels. A new product Create a new product either coffee or decaffeinated product under the Caferoma brand. Stretching the brand Selects few manufacturers of coffee equipment such as cafetieres, percolators, coffee machines, etc to use Caferoma brand on their goods...

Words: 252 - Pages: 2

Free Essay

Untitled

...CONTENTS: Define Reformation?………………………………………page 1 Explain why people went to church in 1500? What religion were they?.... ……………………………………page 2 What were the criticisms of the church in the church?............................................................page 3 What did the protestant want..........................page 4 What was henry the VIII’s role in changing the church? What were his problems? …………………page 5 What where henry’s changes in the church? How did they affect people’s lives?................................page 6 Edward VI why did he build on his father’s changes in the church?......................................................page 7 Mary I why did she change the church? What were here changes?................................................. page 8 Elizabeth I how did Elizabeth change the church? How she tried to please everyone?..........................page 9 Conclusion: how did the English Reformation change people’s lives and method of worship?............page 10 Define Reformation? Explain why people went to church in 1500? What religion were they? What were the criticisms of the church in 1500? What did the protestant want? What was hennery VIII’s role changing the church? What were his problems? Who advised him? What action did he take? What were henry’s changes in the church? How did they affect people’s lives? (Monks, Priests, ordinary people) Edward VI why did he build on his father’s changes in the church? What were...

Words: 293 - Pages: 2

Premium Essay

Untitled

...In The Medium Is the Message by Marshall McLuhan, he explores new media in its most original, basic and pure way as an object, furthermore, he use the idea of the medium itself carries the message rather than the message, furthermore, to analyze how new media influence in the society. At the end, McLuhan explain the role of broadcast television (as a new medium) and how television itself become a “fixed charge” in people’s day-to-day living which we simply cannot live without it. (Marshall McLuhan 1962, p.209) Base on Mcluhan’s notion of how a medium formed in the past, if the idea still apply to the mass communication media nowaday as the media themselves shape the society regardless of the content it carries, or there is a new relation between the media and the society. The way Marshall McLuhan looks at the medium is that he emphasizes on the extension of one sense over the others as a defining feature of a medium. For instance, the electric light is a medium without a message (as an object), the electric light itself is the purest form of information, and people seem to be blinded by the content and forgot its original form. The key that change the perception of an electric light from a medium to a message is how it is arranged in a wave of sequence or used in different activities in order to communicate with the society, therefore create a message and fulfill its purpose. For McLuhan, an electric light is the birth of a new medium. (Marshall McLuhan 1962, p.203) “He imagine...

Words: 1328 - Pages: 6

Premium Essay

Untitled

...Where now? Who now? When now? In front of me was a vast of blankness. I took a deep breath. It was as if I was in a magical, nonrealistic world. I took one tiny step. Paused. Then I sensed my surroundings. There was no one following every movement I make. I twirled around. My surrounding was empty. I let out a small yelp. Then I screamed, "AHHHHHHHH!" All I heard was my echo. I took another deep breath. Then I thought to myself, so this is what it is like to be alive. For twenty years, I was contained in a house that lacked every form of love and affection vital for the growth of a child. Since my parents were one of the richest and fastest growing money makers in the world, our home was a five acre mansion with twenty rooms, fifteen bathrooms, ten gardens, and five swimming pools. Yet all this was for me, and only me. My parents are frequently away due to work, and as a result, I was left alone in this enormous house for the most of my past twenty years. Due to their extreme wealth, my parents have developed a paranoia for everything. Our so called house is contained with high electrically charged walls, protected with over twenty advanced security systems, and the absurdity just goes on. From the moment I was born, I was protected like the most fragile and valuable being in the world. Not because they loved me with all their hearts, but because they were afraid of me getting kidnapped. As a result, I have lived twenty years without any exposure to the vast world out that where...

Words: 1274 - Pages: 6

Free Essay

Untitled

...Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well, sorry. Well,...

Words: 917 - Pages: 4

Free Essay

Untitled

...Legal consciousness is the basis for the legal system; within the framework of legal consciousness are Before the Law, With the Law and Against the Law these concepts are represented within the story of these three women. The three women involved in this story all have the same problem with the principal of the school they work at, they are all being harassed mostly in the same way. The three women’s names are Alicia, Clara, and Bella; they all go about handling their similar situation differently. I came to see that each woman represented Before the Law, With the Law, and Against the Law. Alicia went about solving her problem Before the Law, Bella solved her problem Against the Law and Clara was With the Law. I will analyze each of their specific situations and explain how each is represented in each case. Firstly, Alicia has been a teacher for a couple of years and the assistant principal has being causing serious problems for her. I believe she went about handling her situation by using the Before the Law legal consciousness. I believe she represents the Before the Law legal consciousness because she follows the rules of the system, she collected her data and took notes about the situations that the assistant principle put her in. She very quietly started to find out how to go about filing a legal complaint about her colleague. She then learned all she can learn about how to go about the situation and waited for the best possible moment to file the complaint. Once she filed...

Words: 1457 - Pages: 6

Free Essay

Untitled

...Health Benefits of Power Plate Therapy Health Benefits of Power Plate Therapy * Immediate improvements in blood circulation * Increased muscle strength and flexibility * Increased joint range of motions * Decreased cellulite * Increased bone mineral density * Reduced pain and soreness * Faster recovery and regeneration from injury and training, (research support includes Moezy et al (2008), that indicated enhanced recovery from anterior cruciate ligament reconstruction surgery using vibration technology during rehabilitation) * Enhanced metabolism and lymphatic flow and reductions in cortisol (which is a stress hormone) * Little impact on the joints and ligaments * Capacity for whole body massage and relaxation * Increases the production of collagen to encourage firmer, smoother skin * Helps prevent age-related muscle loss, bone density loss and skin wrinkles * People with medical conditions can exercise while working within their personal physical limitations * Helps prevent injuries through enhanced proprioceptive awareness and control * Immediate improvements in blood circulation * Increased muscle strength and flexibility * Increased joint range of motions * Decreased cellulite * Increased bone mineral density * Reduced pain and soreness * Faster recovery and regeneration from injury and training, (research support includes Moezy et al (2008), that indicated enhanced recovery from anterior...

Words: 266 - Pages: 2

Free Essay

Untitled

...Rhetorical Analysis- The Great Gatsby Although Gatsby would be considered the main character, the story is told through Nick's eyes. Plain, boring, analytical, safe Nick. I think the purpose of that is to show the characters and the story through the least judgmental eyes in the book. Nothing every really happened to Nick. He never lost someone he loved and valued so deeply, he never felt oppressed or glorified or even noticed. Nick was the most sensible of them all, besides maybe Jordan. He wasn't vain or cruel or haughty. He was an honest man, who happened to be in the middle of a whirlwind story. Despite Nick being the fly on the wall, we usually can't tell what's happening or what's going to happen based on his own judgments, primarily because he almost never has one. However, the way the other characters treat and interact with Nick can give you more clues than anything else. If something horrible has happened, the way they treat Nick will give you a hint of what happened before its explained in the book. For the most part, Nick isn't very prevalent, other than the fact that every other character seems to trust him enough to fill him in on the latest detail of their lives, thus giving us multiple POV's and the ability to completely piece together the story with...

Words: 287 - Pages: 2

Premium Essay

Untitled

...Communicating in Style: Discover How to Communicate with Everyone (and Like It!) By Julie Barrett, PinnacleOne Communication; a simple yet powerful word. A word that is understood by the masses and still remains a mystery in its effectiveness. Communication can be the making or breaking of all relationships. You have been there; I know you have. Trying to convey a tidbit of vital information to a coworker or a supervisor. You have rehearsed your lines, reviewed your facts, and you know the delivery to use because you are a communicator. Your very job exists because you a conversationalist. Right!? So why is it then when you do explain your ideas and expel your thoughts that the other party just doesn’t get it! Your boss stares at you like you are an idiot. It isn’t you with the communication problem, it’s him. He’s the boss who is supposed to be the master of all communication styles. So why doesn’t he understand? That blank look on his face is as if you presented your ideas in a foreign language. The more you talk the less engaged your boss becomes until you have a major disconnect and you leave his office frustrated and confused. What went wrong? How can you be so prepared and have accomplished nothing? Welcome to the world known as the “Communication Abyss.” The art of getting your message across effectively is a vital part of being successful in today’s marketplace. Whether you want to have a simple conversation, give directions, make presentations with confidence or to negotiate...

Words: 4901 - Pages: 20

Free Essay

Untitled

...Source: EDAS as of 26 Feb 2004 and MILPER Msg 04-145, dtd 20 April 2004 ASSIGNMENT ELIGIBILITY AND AVAILABILITY Code Definition A PERMANENTLY INELIGIBLE FOR FUTURE ASSIGNMENT B UNDER CONSIDERATION FOR ELIMINATION FROM SERVICE C TEMPORARILY INELIGIBLE FOR OVERSEA ASSIGNMENT D Soldiers WHO HAVE RECEIVED AN INVOLUNTARY FOREIGN SERVICE TOUR EXTENSION (IFSTE). TERMINATION DATE WILL BE THAT OF THE SOLDIER'S ADJUSTED DEROS. TOP OF THE SYSTEM INPUT ONLY. E KOREA ASSIGNMENT RENEGOTIATION F SOLDIERS ON ASSIGNMENT INSTRUCTIONS (AI) TO KOREA WHO INTEND TO ACCEPT ASSIGNMENT INCENTIVE PAY (AIP). THERE IS NO TERMINATION DATE. G SPECIAL CATEGORY STABILIZATION H PENDING APPROVAL FOR RETIREMENT (OTHER THAN EARLY I WARRANT OFFICER/OFFICER CANDIDATE SCHOOL PENDING J PENDING ACTION BY A MEDICAL EVAL BOARD/PHYS EVAL K STABIL OCONUS DEPLOY/REDEPLOY 61 TO 139 CONSECUTI L FULLY ELIGIBLE FOR PCS REASSIGNMENT M REENLISTMENT/RECLASSIFICATION IN PROGRESS N DEPLOYMENT STABILIZATION O STABILIZED - OPERATIONAL DELETION P SOLDIERS ON AI TO KOREA, OR ALREADY IN KOREA, WHO HAVE DECLINED AIP AND ARE AVAILABLE FOR REASSIGNMENT UPON DEROS. Q INELIGIBLE FOR ASSIGNMENT UNDER THE LAUTENBERG AM R STABIL OCONUS DEPLOY/REDEPLOY 140 OR MORE CONSECU S STABILIZED - EXTREME FAMILY PROBLEMS T PERFORMING DUTIES DIRECTED BY HRC U ENLISTMENT COMMITMENT V INDIVIDUAL STABILIZATION W ORGANIZATIONAL STABILIZATION X ROTC, RECRUIT CMD, FULL-TIME MANNING FOR RC UNITS Y DEPENDENT AWAITING GRADUATION AS A SENIOR...

Words: 309 - Pages: 2

Premium Essay

Untitled

...To what extent was the Iraq-Kuwait Gulf War Conflict provoked by internal forces? International History Ben Aston 24.04.03 Iraqi forces invaded and annexed Kuwait on 2 August 1990. Within twenty four hours Kuwaiti military resistance had effectively ceased, and the government and emir of Kuwait had fled to Saudi Arabia. A puppet administration was installed and Kuwait was declared to be a province of Iraq. The Persian Gulf War, more commonly referred to as the Gulf War, which began in 1990 and continued through to 1991was driven by a myriad of internal factors. But to what extent were external factors instrumental in the provocation of war? Can some blame be attributed to external forces or would the conflict have occurred despite their involvement and influence? In this essay, the Iraq-Kuwait Gulf War will be understood to mean the conflict which began with Iraqi incursions into Kuwait in 1990 and the subsequent events and conflict which continued during early 1991 until 28 February when a ceasefire was declared. Many Gulf War theorists believe the Gulf War was internally provoked and believe a large portion of the blame can be held to Saddam. Lawrence Freedman suggests “real responsibility [for the Iraq-Kuwait conflict] lies with Saddam Hussein, for the origins of the crisis are to be found in his chronic political insecurity and the lengths to which this drove him.”[1] Although there were many factors which led to Saddam’s...

Words: 2208 - Pages: 9

Free Essay

Untitled

...The words that I have chosen are to represent Macbeth, throughout the play Macbeth became heartless after the murders he had committed. Macbeth became a danger to everyone by his actions and deeds. He chose to cut his emotions off because he knew that it would be the only way for him to successfully do whatever it took to fulfill the prophecies that the witches had told him. He did whatever he had to do in order to get what he wanted. When Lady Macbeth committed suicide Macbeth took it in a nonchalant manner; however he pitied her for her weakness. He was evil itself, he was darkness, like a nightmare come true. This quote relates to Lady Macbeth, throughout the play Lady Macbeth so desperately wanted Macbeth to become king. She wanted him to become king so much that she convinced Macbeth to kill King Duncan. She was so corrupt that she even helped to finish the cover up of King Duncan’s murder by taking the daggers back to the room. Lady Macbeth wanted to be on top, she wanted to rule Scotland. She, like her husband was willing to do whatever it took to get what they wanted. Her wish for Macbeth to become king came true, but the guilt of the murders made her horrified and she committed suicide. This quote reminds me of Malcolm, after the death of his beloved father he fled in fear that him or his brother would be next. He knew that evil was among Scotland, but never understood why someone so evil and malicious would want to kill his father. He couldn’t live...

Words: 766 - Pages: 4

Free Essay

Untitled

...Chapter 3: Relational Model Chapter 3: Relational Model 1 1 Objectives 2 2 Logical View of Data 3 2.1 Table characteristics 3 2.2 terms 3 2.2.1 domain 3 2.2.2 primary key 4 2.2.3 abstract data type 4 2.2.4 tuple 4 2.2.5 attribute 4 3 Keys 4 3.1 determinant 4 3.1.1 functional dependence 4 3.1.2 multi-functional dependence 5 3.2 types of keys 5 3.2.1 super key 5 3.2.2 candidate key 5 3.2.3 primary key 5 3.2.4 alternate key 5 3.2.5 foreign key 5 3.2.6 secondary key 5 3.2.7 composite key 6 3.3 entity integrity 6 3.4 referential integrity 6 4 DB Integrity 6 4.1 domain integrity 6 4.2 entity integrity 6 4.3 referential integrity 6 4.4 business rules 6 5 Relational DB Query Languages 6 5.1 relational algebra 6 5.1.1 select 7 5.1.2 project 8 5.1.3 join 8 5.1.3.1 equa-join 8 5.1.3.2 theta-join 9 5.1.3.3 natural join 9 5.1.3.4 outer join 10 5.1.4 intersect 11 5.1.5 union 11 5.1.6 difference 11 5.1.7 Cartesian product 12 5.1.8 division 12 5.2 relational calculus 13 6 Meta Data Components 13 6.1 data dictionary 13 6.2 system catalog 13 6.2.1 synonym 14 6.2.2 homonym 14 7 Relationship Types 14 7.1 1:1 14 7.2 1:N 15 7.3 M:N 16 7.3.1 intersection table 16 7.3.2 dummy table 17 8 Data Redundancy in Relational Model 17 9 Indexes 17 9.1 pointer 18 9.2 unique index 18 9.3 non-unique index 18 1 Objectives • The relational database model takes a logical view of data. • The relational model's basic components are entities, attributes...

Words: 2530 - Pages: 11

Free Essay

Untitled

...In 1989, Stephen R. Covey penned The 7 Habits of Highly Effective People(public library), a book that went on to sell millions of copies worldwide and defined a new genre bridging self-improvement, business management, and personal productivity. This week, Covey died at the age of 79. Here's a look back at his legacy with some of the keenest insights from his beloved bestseller. Habit is the intersection of knowledge (what to do), skill (how to do), and desire (want to do). Sow a thought, reap an action; sow an action, reap a habit; sow a habit, reap a character; sow a character, reap a destiny.* People can't live with change if there's not a changeless core inside them. Until a person can say deeply and honestly, 'I am what I am today because of the choices I made yesterday,' that person cannot say, 'I choose otherwise.' To learn and not to do is really not to learn. To know and not to do is really not to know. It is one thing to make a mistake, and quite another thing not to admit it. People will forgive mistakes, because mistakes are usually of the mind, mistakes of judgment. But people will not easily forgive the mistakes of the heart, the ill intention, the bad motives, the prideful justifying cover-up of the first mistake. Admission of ignorance is often the first step in our education. Our behavior is a function of our decisions, not our conditions. The ability to subordinate an impulse to a value is the essence of the proactive person. How you treat the one reveals...

Words: 366 - Pages: 2