It525 Assignment 2

1197 words - 5 pages

Database Design and Data Modeling: Assignment 2

Mohammed Azrak

Kaplan University

Database Design and Data Modeling: Assignment 2

Question #1 Definitions:

Define each of the following terms (1 pt. each). In addition, provide an example of each term (2 pts. each).
a. Business Rule
b. Entity
c. Entity Set (Entity Type)
d. Entity Instance
e. Attribute
f. Relationship
g. Connectivity
h. Cardinality Constraint
i. Participation Constraint.
j. Associative Entity

Answer #1:

a. Business Rule – a description of a policy, procedure or principle within an ...view middle of the document...

For example, an employee works for one or many departments.

i. Participation Constraint - is when a certain relation can only have at a maximum of one instance for a relationship. For example, an employee does not work for a department or at most only one department.

j. Associative Entity – is an element of the ER model also called resolving entities to resolve issues with many to many relationships. For example a student registers a course and many students registers many course where “register” is the associative entity.

(Coronel, Rob, & Morris, 2012).

Question #2 Explanation of each row in the 4-row format:

Please use this four-row format when writing your connectivity-determining business rules.
Figure 1. Publisher Database
Explanation of each row in the 4-row format:
(1) Write the entity pair. Underline and/or bold.
(2) Give one business rule. Indicate the multiplicity of that rule in parentheses.
(3) Give the other business rule. Indicate the multiplicity of that rule in parentheses.
(4) Give the connectivity. (If the connectivity is M:N, give the associative entity name.)
Following is an example of the required four-row format for business rules for a binary relationship for this Assignment.
Publisher – Book
ONE Publisher may publish MANY Books [M]
ONE Book has ONE Publisher [1]
Publisher 1:M Book.
Complete the same 4-row format for the remaining relationships in the ERD illustrated in Figure 1.
The Unit 2 Enrichment Seminar will have more information about writing these rules and for determining, in a one-to-many relationship, which is the "1" entity type and which is the "M" entity type.
Be sure the connectivity row for each 1:M relationship has the correct direction. The rule with the multiplicity "many" will determine the direction. For example, if the rule is: "ONE Publisher may publish MANY Books", then Publisher is the "1" table and Book is the "M" table, so you would write the connectivity as: Publisher 1:M Books.
Use the four-row format to write the business rules and connectivity for the three binary relationships other than Publisher – Book.

Answer #2:

1) Author – Book
2) MANY Authors may write MANY Books [N]
3) MANY Books has been written by MANY Authors [M]
4) Author M:N Book. Requires associative entity: AuthorBookWrite
1) Country - Author

2) ONE Country has MANY Authors [M]

3) ONE Author is a citizen of ONE country [1]

4) Country 1:M Author

1) Book - Volume

2) ONE Book has MANY Volumes [M]

3) ONE Volume may have ONE Book [1]

4) Book 1:M Volume

Question #3 Primary Key / Foreign Key Placement:

The primary key of a table is often named after the table. Example: ISBN-13 would be chosen as the name of the primary key for the Book table. For each entity set in the table below, give the primary key attribute(s) and the foreign key attribute(s) (if any).

Other Essays Like It525 Assignment 2

The French And Indian War: The "Real" First World War

1955 words - 8 pages The Seven Years War, or more commonly referred to as “The French and Indian War”, has been called the true First World War. In this book The French and Indian War: Deciding the Fate of North America, the author and historian Walter R. Borneman paints a detailed and elaborate picture that justifies the claim of it being the first true war of global proportions. If ever there truly was a climax to the never ending feud of the European powers

Is The Use Of Animals In Medical Research A Necessary Measure?

1513 words - 7 pages research (Thomassen 2). During his time, religion played a main role in society, making people believe they were supreme rulers over all other living beings on the earth as stated in the bible. Because of this fact, humans and animals were not linked and research was conducted only to learn more about non-human species. It was not until 1859 when Charles Darwin came up with his theory of evolution that human and animal body systems were connected

Education And The Evolving Job Market

2363 words - 10 pages academic abilities (Anderson, 2007). According to Gregory and Chapman (2007), through differentiation educators are able to “give all students an opportunity to learn to their full potential.” The authors furthermore state instructors who support this philosophy have several key beliefs about the learners they teach. These include: (1) every student has his own areas strength and weakness, (2) each student has the abilities and capacities to

Young And Relentless

1737 words - 7 pages There are numerous influences that can be responsible of teenager’s behaviors and attitude as they develop. One factor that is important to these behaviors is parental figures being over involved or uninvolved in their children’s lives. Many of these effects include illegal substance abuse, rising sexual activity, underage alcohol consumption, and tobacco use. Studies show parental participation plays a key role in the characteristics developed

The Natural Law Theory

1231 words - 5 pages Obeying by the natural law theory is the only true and moral way to live life; especially a life lived in God’s image. God’s presence is a guiding factor to obtaining a moral and virtuous life, which can only be obtained by following the natural law theory. God created a set of laws as a supreme guide for humans to live life, like any law these laws were created to ensure wellbeing for everyone. The laws he created are the civil law, the natural

Resolved: Presidential Signing Statements Threaten To Undermine The Rule Of Law And The Separation Of Powers

1811 words - 8 pages The subject of signing statements has created much debate among the houses of Congress, government officials, and the public alike. These signing statements fall under the categories of constitutional and legislative history signing statements. Constitutional signing statements are those in which the president deems certain provisions of the legislation as unconstitutional, therefore they should not be enforced (Bradley & Posner, 2006

Oppressive Systems Of Government In Egypt And Animal Farm

1529 words - 7 pages As in Egypt, Orwell demonstrates through his allegorical novel “Animal Farm” that leaders are able to establish and maintain power over a people, and in turn create an oppressive and corrupt government system. Orwell shows the significant difference in the education and levels of knowledge in the animals, and how the government takes advantage of this difference. The split between the levels of intelligence is portrayed in the first chapter when

The Pathway To Psychosis

1415 words - 6 pages “How all occasions do inform against me” is a line from act IIII, scene IIII of William Shakespeare’s Hamlet. This line, spoken by Hamlet, expresses his emotional state as he is currently overwhelmed by the death of his father, the king of Denmark, and the situation surrounding it. After Hamlet learns of his father’s death he finds out that his mother has married Claudius, Hamlet’s uncle. On top of all of that, Hamlet soon after

Rated “M” For “More Censorship Not Needed”

1241 words - 5 pages Since the moment video games became a commercial success there have been people who have pushed for unfair amounts of censorship to be placed upon the content of the games and its availability to children. These groups push for increased regulations on content but there is already an appointed group to handle this issue, the ESRB. Even though there has been an increase in mature content in the video game industry, increased censorship is not

Four Components Of A Legally Astute Social Media Marketing Manager

1914 words - 8 pages With the advances in technology constantly changing companies have to find better ways to market their products to consumers. The explosion of Facebook has given companies a way to market products to consumers. Examine how a legally astute manager can use social media to his advantage. Review different forms of dispute resolution and determine which one works the best. What is the best course of action, the government can use to

Obama's Values

1217 words - 5 pages As individuals, we don’t tend to take action unless it’s for self-interest; however, in Dreams from My Father, Obama spends three years, after college, as a community organizer in Chicago. Obama goes through tribulations, disappointments, and even complete failures organizing meaningful events, decisive meetings, and humble gatherings but he keeps working toward achieving any possible change in the community. Even though results give him every

Related Papers

The Separation Of Capital Ownership And Control

1577 words - 7 pages The argument of whether the separation of capital ownership and control is an efficient form of organization has constantly been a controversial issue. The criticism whether the controllers’ act is in the best interest of the owners’ wills never end as long as hired managers operate management. As the number of public companies has been increasing over the course of this century, meanwhile the American style of contact based corporation has

The Versatility And Flexibility Of Oled's

1014 words - 5 pages In April 1, 2002, organic light emitting diodes gain rise in the scientific community with their published, more practical form at Ames Laboratory. “Scientists at the U.S. Department of Energy's Ames Laboratory, in collaboration with scientists at the University of Michigan, Ann Arbor, have developed and demonstrated a novel, fluorescence-based chemical sensor that is more compact, versatile and less expensive than existing technology of its

Comparing The Moral Virtues Of Antony And Julian The Apostate

1103 words - 5 pages Roman emperor Julian the Apostate and Christian leader Antony both exhibited many qualities of character during their existence. Both of them led very distinctive lives although shared several ethical values. Book 25 of “The Later Roman Empire” and the book “Early Christian Lives” show concrete evidence of this. In the following essay, I will argue how both leaders’ lives were devoted to their religious beliefs and their mutual cardinal virtues

Living In A Cashless Society Essay

1637 words - 7 pages Money in a traditional sense no longer exists. Money is becoming much of a concept than a physical material, and most ordinary bitter have not see the reality of the switch. People today are using credit and debit cards on a regular basis and in everyday situations such as meal purchased at fast food, highway tolls, clothing, groceries, gas stations, etc. all of these means of systems could be regarded as a cashless society or world. The question