Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

The ________ rule specifies that an entity can be a member of only one subtype at a time.

18/11/2020 Client: papadok01 Deadline: 24 Hours

ISYS Managing Enterprise Data 464

Your answers are expected to be as detailed as possible as points will be deducted if your diagrams/models do not contain their key elements. (primary keys, subtype discriminators, titles, dependencies, foreign keys, among others…) with proper representation (underline, arrows, bold,…)

1. Answer the following multiple choice by choosing the right answer. (Only one possible answer for each question) (30 pts, 2 pts each)

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

A) two

B) three

C) one

D) zero

An employee can work in more than one department but does not have to work for any department.

B) A department must have at least one employee.

C) A department can have more than one employee.

D) An employee has to work for more than one department.

Which of the following criteria should be considered when selecting an identifier?

A) Choose an identifier that is not stable.

B) Choose a null identifier.

C) Choose an identifier that doesn't have large composite attributes.

D) Choose the most complex identifier possible.

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

A) one-to-one

B) many-to-many

C) one-to-many

D) strong

The ________ states that no primary key attribute may be null.

A) referential integrity constraint

B) entity integrity rule

C) partial specialization rule

D) range domain rule

Which of the following is an entity that exists independently of other entity types?

A) Codependent

B) Weak

C) Strong

D) Variant

The number of entity types that participate in a Unary relationship is:

A) zero.

B) one.

C) two.

D) three.

The process of defining one or more subtypes of a supertype and forming relationships is called:

A) specialization.

B) generalization.

C) creating discord.

D) selecting classes.

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.

A) disjoint

B) overlap

C) completeness

D) weak

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.

A) disjoint

B) overlap

C) partial specialization

D) total specialization

The process of defining a more general entity type from a set of more specialized entity types is called:

A) generalization.

B) specialization.

C) normalization.

D) extrapolation.

The ________ rule specifies that an entity can be a member of only one subtype at a time.

A) exclusion

B) disjoint

C) removal

D) overlap

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

A) column.

B) foreign field.

C) primary key.

D) duplicate key.

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.

A) partial key-based

B) partial functional

C) cross key

D) merged relation

Which of the following are properties of relations?

A) Each attribute has the same name.

B) All columns are numeric.

C) There are multivalued attributes in a relation.

D) No two rows in a relation are identical.

2.

Based on the following scenario, draw an EER Diagram for FRAM indicating ALL the cardinalities. If the information provided are not enough, state any assumptions that you made while drawing your diagram.

The FlyRight Aircraft Manufacture (FRAM) division of the FlyRight Company (FRC) performs all maintenance and production for FRC’s aircraft. Since FRAM has several employees each with specific roles, it is essential for FRAM to keep records about their employees.

FRAM has about 20 different type of employees, including mechanics, designers and engineers. Each employee is assigned a unique identification number. The company also has information about the name, date hired, address (including city, state, and zip), email address and type of each employee. Each engineer has a research area that must be kept tracked of.

Each mechanic is specialized in 2 possible areas and it is not unusual for a mechanic to have both specializations. Some mechanics are specialized in engine(EN) maintenance and are required to possess a clearance level which must be saved by FRAM.

Some mechanics are specialized in airframe (AF) maintenance and are required to take periodic refresher courses. FRAM tracks all course taken by each AF mechanic and store the completion date, certification (Y/N), and performance. Each course can have multiple AF mechanics enrolled at the same time and each AF mechanic can only enroll in one course at a time.

3.

For each of the following sub-question a, b, c and d :

· Indicate the form (1NF, 2NF or 3NF) of the presented relational model

· If required, convert this form to a 3NF relational model.

· You can use the rectangles at the end to draw your model. DO NOT FORGET to indicate which question (a or b ) you are answering.

Note that candidate key are indicated in bold and underline.

a. (10 pts)

Current form : _____

b. (10 pts)

Current form : _____

c. (10 pts)

Current form : _____

d. (10 pts)

Current form : _____

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quality Homework Helper
Top Essay Tutor
Helping Hand
Buy Coursework Help
Writer Writer Name Offer Chat
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Voltage divider under load - How to remove acrylic nails with acetone at home - SSGB - Discussion board - Research paper 8 - Solve the differential equation y xey - Easy Computer Assignment - Gracelink kindergarten 2015 - Psy 2012 final exam broward college - American radio history billboard - Intellectual interests - Firms pursuing a cost leadership strategy are typically characterized by - Geos search and rescue benefit - Mecu limited asset management arm - Ethical Dilemmas - Hepatitis prefix and suffix - Clipper circuit on breadboard - Broad street plaza nhs - Rosencrantz and guildenstern are dead questions and answers - Nurs495prompt - Dbs301 seneca - Function of micronucleus in paramecium - Supertoys last all summer long character analysis - 3 pages essay - Figurative language meaning and examples - Apple cider vinegar for vaginal itching - Mrs spring fragrance literary analysis - Bleaching hair orange stage - Kicking a soccer ball - Logic the essentials answers - Http www personal psu edu faculty j 5 j5j ipip - Kagan rally coach worksheets - Grader Project: Access Chapter 3 Capstone - Brilton Madley Games - Business finance acc501 assignment no 01 - Alcoholic fermentation in yeast lab answers - Boyd orr car park - Social psychology in action presentation - The great powers divide china - Gotham deserves a better class of criminal - Hyundai motors is considering three sites - Tpg adsl2+ off net - Assignment Help- Website hosting and Contenet management - Final Paper: Personality Theory - Case Study: Mr. C. - Citrix receiver 32 bit windows xp - I need a case study on how The nurse sensed that something significant to Ann and Ben was unfolding. - Circumcision power point - Adeline yen mah siblings now - Decision making process assignment - Bangor university marking grades - Hoa lac hi tech park - Coll Bargain 5 - Thermionic emission work function - David dorton mckinsey - Incentive motivation definition psychology - Move your hyde groupon - Brown black yellow resistor value - Cdu apa referencing guide - Emile benveniste subjectivity in language - Physical threat to information systems? Fire? Hurricanes? Sabotage? Terrorism? - Lc grad2 gcu - Barwon community legal service - Mintzberg managerial roles with examples pdf - Ziona chana net worth - Risk management approach template - Do kangaroos migrate or hibernate - Change into 12 hour clock time - Kohinoor textile mills products - Logistic - Small business management - Irwell unit fairfield hospital - Locked bag 5136 parramatta nsw 2124 - Threat of new entrants airline industry - The breakfast club communication analysis - How to make sieve analysis graph - Hr discussion - Killing us softly 4 free online - Triangular trade route map - HW5 - MATH - Gri g4 guidelines ppt - Mackillop family services mission - Analysis of case study healing and autonomy - Week 6 Final - Augmentative Communication Devices - Eastern michigan university murders 1967 - Criminal justice/affidavit/complaint offense#1 - When a firm has dividends in arrears - Python code - Lab 14 locations of mountains earthquakes and volcanoes - Pilot air compressor ns39 - Ethics in animal research ppt - Article Review - Far West Discussion - Second warning letter to employee - Pandora jewelry competitive advantage - Fe acac 2 - St john dress 14 - Taelln411 answers - C2h5oh polar or nonpolar