What would be ER association relationship types

Assignment Help Basic Computer Science

Reference no: EM132453513

1. What would be ER entity types that could be drawn from this description?

2. What would be ER association relationship types that could be drawn from this description? Specify all entity types that belong to each relationship type.

3. What would be ER generalization/specialization relationship types that could be drawn from this description, if any? Specify all entity types that belong to each relationship type.

4. For each of the association relationship types, specify the cardinality and participation constraints.

5. For each of the generalization/specialization relationship types, specify whether the relation is mandatory or optional and whether the specializations are disjoint or overlapping.

Using the Dia tool, draw the ER diagram that represents the data model from problem 4. Include for each entity type the attributes and the primary key.

6. Identify the relational database tables that would implement the ER diagram from problem 4. Specify the table attributes and the primary key and foreign key choices that would implement the ER diagram.

Reference no: EM132453513

Questions Cloud

Securing IoT Devices-What are the Challenges : Securing IoT Devices: What are the Challenges? Design a technical solution to reduce security vulnerabilities;

Aware of the problems associated with the use of iot devices : Explain in detail, in a step-by-step guide, how to make people more aware of the problems associated with the use of IoT devices.

Describe the process of certification and accreditation : How would you describe the process of certification and accreditation? Would this opinion regarding accreditation hold true for other organizations? Explain.

How might offices physically change in the coming years : How might offices physically change in the coming years? Will offices as we think of them today exist in the next ten years? Why or why not?

What would be ER association relationship types : What would be ER association relationship types that could be drawn from this description? Specify all entity types that belong to each relationship type.

Create A Security Plan : Cyber Security Framework (CSF) to create a security plan for the Cloud. Make sure the plan covers the categories and sub categories of the NIST CSF framework

Facial recognition is biometric software application : According to techopedia, facial recognition is a "biometric software application capable of uniquely identifying or verifying a person by comparing

Big data fraud management : Big data fraud management. Is it possible to implement Alibaba style of fraud management (risk analysis) for US based institutions?

Articles on the topic of big data and business impacts : Research at least two articles on the topic of big data and its business impacts. Write a brief synthesis and summary of the two articles.

User Account

All Pages