Entity relationship in a physical relational database design

Assignment Help Database Management System
Reference no: EM131524495

Question 1. Maximum cardinality refers to _____.
the most instances of one entity class that can be involved in a relationship with one instance of another entity class
the maximum number of entity classes involved in a relationship
whether or not an instance of one entity class is required to be related to an instance of another entity class
whether or not an entity is a weak entity
None of the above

Question 2. The characteristics of a thing are described by its _____.
identifiers
entities
objects
attributes
relationships

Question 3. The identifier of the entity becomes the _____ of the corresponding table.
A. primary key
B. foreign key
C. supertype
D. subtype
Both A and B

Question 4. In a relational database design, all relationships are expressed by _____.
creating a primary key
creating a foreign key
creating a supertype
creating a subtype
creating a line between entities

Question 5. In relational database design, ID-dependent entities are used to _____.
represent N:M relationships
handle associative relationships
handle multivalued attributes
handle archetype/instance relationships
All of the above

Question 6. Match the following terms to their definitions.
Potential Matches:

1 : something that the users want to track in their environment

2 : an entity whose identifier includes the identifier of another entity

3 : describes characteristic of an entity

4 : an entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity

5 : an entity that holds specialized attributes that distinguish it from one or more other similar entities

Answer

: ID-dependent entity

: Subtype

: Weak entity

: Attribute

: Entity

Question 7. How would you represent a one-to-many strong entity relationship in a physical relational database design?

Reference no: EM131524495

Questions Cloud

What is critical r value for which optimal decision changes : Consider once again Fred Wallace's decision in the Strenlar case study at the end of Chapter 4. What if Fred is risk-averse? Assume that Fred's attitude toward.
String class methods length and substring : Suppose s is some string that has been created inside main, and suppose s.length() is greater than 3 (so s has more than 3 characters).
Analyze the main potential benefits of learning about health : Analyze the main potential benefits of learning about health economics related to private sector government involvement in healthcare economics and delivery.
Specifications for the new satellite campus : The IT leadership team has determined that the college will add another satellite campus that will have a Learning Center with 20 computers and 10 classrooms.
Entity relationship in a physical relational database design : How would you represent a one-to-many strong entity relationship in a physical relational database design?
Explain why the axioms are important to decision analysis : Most people are learning constantly about themselves and their environment. Our tastes develop and change as our environment changes.
Develop your strategic leadership plan : During that time, you've developed your Strategic Leadership Plan (Project Parts I, II, and III) to take the organization forward.
Find the value for p : Find the value for p that makes you indifferent between Lottery 1 Win $1,000 with probability p.
Critical document and pictures on desktop : What will you do if you need to back up more copies of your critical document and pictures on your desktop if you are using cloud storage?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Assume that you would like mary to be able to verify that

Assume that you would like Mary to be able to verify that all your email mes- ages are really sent from you. How can you authenticateyour messages without encrypting the actual text?

  Describe product characteristics and deliverables

Develop a scope statement for the project and describe product characteristics and deliverables.

  Normalize the following table into first normal form

Normalize the following table into first normal form. The table uses one row to record information about each student. A student may take one or more electives. This table is not in 1NF. Normalize this table so it is in 1NF. In your answer, list a..

  Objectives of file management principle

What are the requirements to ensure the objectives of file management principle is realized?

  Add a new customer to our list of customers

List the rental identification number, make, model, year, classification, and rental duration for each of our locations for the month of October, 2015.

  Explain the reasons of erps in emerging markets

ERPs in emerging markets converged toward ERPs in developed markets between 2008 and 2012. Explain reasons for this trend.

  Identify the behaviors that created this environment

Identify the behaviors that created this environment. What behaviors would change this into a nurturing climate?

  Construct a relational database for leslies auto sales

Vehicle Identification Number, Manufacturer, Model, Year, Sticker Price Leslie' s, including the date of the sale and the negotiated price. Construct a relational database for Leslie's Auto Sales.

  Write a sql query to display order id and order date

Write a SQL query to display order ID and order date for all the orders made by customers in the territory of Southwest (use WHERE command to join tables). Use sub-query technique to write a SQL query to display order ID and order date for all the..

  Find out what actual operations were performed by surgeon

Find out what actual operations were performed by the surgeon 103. List the surgeon code, the code of the actual operation and the date the operation was performed.

  Determine if the table satisfies 2nf

Determine if the table satisfies 2NF.  If the table is already in 2NF, say so.  If a table violates 2NF, say so and produce the 2NF tables.  It is sufficient to just list the results of 2NF normalization

  Evaluate interface design models and describe design issues

Evaluate interface design models and describe design issues across human-computer interaction environments associated with these models. Support your response.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd