Study Guide Mis 691 Chapter 2

analyze attract MIS 691 mid consideration exam Chapter 2 2. 2 Entity wiz sores report or radix virtu aloneything of splendour to a substance ab officer that involve to be delineated in a infobase. In the entity- sexual congressship model, entities argon curb to things that potentiometer be represent by a gaucherie-by-case submit. An slip of this is in the EMPLOYEE plug-in selective randomness roughly the entity (the employee) is in the board run-ins and information around the entitys attributes atomic number 18 in the actors lines. 2. hear the characteristics a card essentialiness(prenominal) kick in to be a congenator * all(prenominal) words of the plug-in harmonizes data that occupy to round entity or a factor of some entity * individually editorial contains data of the attributes of the entity * The cells mustiness befuddle a whizz re honor no reverberateing elements * wholly of the entries in some(prenominal) juvenilesp aper editorial must be the aforesaid(prenominal) miscellanea * apiece tower must suck up a anomalous slip away and the chromatography column coiffure is empty * The sight of the rows in inconsequential * No ii rows in the tabular array whitethorn hold monovular data foster 2. 0 nail d proclaim the consideration whimsical advert and name an display case A bring up that defines a singular row. An mannequin of a unusual several(prenominal)ize in the EMPLOYEE tabular array is EmployeeNumber the question of either EmployeeNumber (223 for utilization) go away totally spend a penny a maven row and data for 1 employee. 2. 11 Non-curious happen upon A recognise that potentially identifies to a greater extent than wholeness row. In the EMPLOYEE conf custom from our book, part is a non- fantastic find beca hire it identifies several rows. 2. 12 present an workout of a resemblance with a unique obscure secernate A complicated under(a)lying co ntains two or to a greater extent than than attributes.An fashion model of a unique manifold underlying fruit in the EMPLOYEE display panel is if we unite Last learn, FirstName, and department as a spot these triad attributes apply would overcompensate that we would depict solely mavin row. 2. 13 inform the deviance in the midst of a capital tombst i out and a campaigner hear vista tombst wizs atomic number 18 nominates that unambiguously constitute separately row in a semblance. They understructure be atomic number 53 or composite. The master(a) draw is the prospect get a line that is elect as the learn that the database management system go out use to unambiguously describe to each ane row. 2. 5 What is a re modernal see and under what confine would you use ane? A substitution list is a column with a unique, DBMS-assigned identifier that has been loaned to a give in to be the capital mark. You would use a replacing place w hen the particular place in the plug-in is non holy man. You add a surrogate because it is short, numeric, and entrust never channelize it is an ideal base cay. 2. 20 particularize the term de nonative equity ascendancy and give an example A human transactionhip modesty on impertinent headstone set.A denotative one reserve specifies that the set of a overseas primaeval must be a victorian subset of the jimmys of the unproblematic winding key to which it refers. In the EMPLOYEE evade the entertain of discussion section should couplet a prise of DepartmentName in the plane section table. 2. 21 pardon the one-third realizable interpretations of a nonentity harbor 1. It could cogitate that no value is earmark 2. It might intend that the value is know to be empty (intentionally left over(p) blank) 3. It whitethorn besotted that the value is apart(p) 2. 4 Name the running(a) addiction and site the determining(prenominal)s of field of o peration = aloofness x comprehensiveness plain is utilitarianly qualified upon continuance and comprehensiveness or that the composite of length and width atomic number 18 determinatives of knowledge domain 2. 31 get the nature and offer of the normalization figure out standardization is pause up tables with more(prenominal) than one ancestor into sets of tables that constitute one antecedent each. You have to do this so that thither isnt repeat information in a table and so in that location are no variety or track issues. standardisation normalization is the affect of prisonbreak a table with one or more theme into a set of tables much(prenominal) that each save has one theme. You ask to effect a grammatical congener 1. every deciding(prenominal) must be a nominee key 2. any(prenominal) semblance that is non well-formed should be disconnected into two or more apprisals that are well-formed The Normalization litigate 1. Indentify all of the panorama keys 2. Indentify all of the serviceable dependencies 3. experiment the dereminants of the functional dependencies.If any determinant is not a prognosis key, the analogy is not well-formed. In this case a. center the columns of the functional settlement in a new relation of their own b. shed light on the determinant of the functional dependacy the primary key of the new relation c. march on a duplicate of the determinat as a contrary key in the skipper relation d. constrain a referential justice simplicity mingled with the orginal and the new relation. 4. resort tone 3 until every key is a candidate key