Question

In: Computer Science

2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is...

2. Draw an entity relationship diagram (ERD) for the following situation:

The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes researcher name, title, position; university name, location, enrollment; and research interests. Each researcher is associated with only one institution, and each researcher has several research interests.

3. Visit a Web site that allows customers to order a product over the Web (e.g., Amazon.com). Create a data model that the site needs to support its business process. Include entities to show what types of information the site needs. Include attributes to represent the type of information the site uses and creates. Finally, draw relationships, making assumptions about how the entities are related.

Expert Solution

Solution:

Entity Relationship diagram:

Explanation:

Entity: There are three entity present in the entity relationship diagram. Which are

named as Researcher, Institute, and Researcher_Interest.

Attributes: In the figure, the ovals represent the attributes of the entity. The underlined

attributes are called primary key of the table entity.

Relationship: Rhombus are used to tell the relationship between the entities.

1: 1 Relationship: Since each researcher can work in only one institute, therefore, the

relationship between researcher and institute is one to one.

1: n Relationship: since one researcher can work more than one research topic, therefore

the relationship between researcher and researcher_interest is one to many.

note: If you do not get anything in this solution, please put a comment and I will help you out.
if you are satisfied, please give me a LIKE if possible.

venereology answered 1 year ago

case study 1. Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify...

case study 1. Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify correct relationships, attributes, and identifiers (keys). 2. Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+). case: HELP is a voluntary organization that provides aid to people. Based on the following brief description of operations, create the appropriate fully labeled Crow’s Foot ERD. Individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their...

Based on the following situation,draw a complete Entity Relationship Diagram using theCrow’s Foot notation...

Based on the following situation, draw a complete Entity Relationship Diagram using theCrow’s Foot notation which includes:All entities and attributes Relationships Connectivity and relationship participation (4.5 Marks)Primary and foreign keys (3.5 Marks)A lecturer in a university can manage multiple projects. But, it is not compulsory for a lecturer to manage a project. Each project is managed by only one lecturer. Lecturer will have a staff number, a name, a rank, and a research specialty. Projects have a project number, a...

Use information from text to create (ERD) Entity Relationship Diagram . Make sure relationship sentences are...

Use information from text to create (ERD) Entity Relationship Diagram . Make sure relationship sentences are consistent with relationship in ERD. Video Store (AVS) runs a series of fairly standard video stores: • Every customer must have a valid AVS customer card in order to rent a video. Customers rent videos for three days at a time. Every time a cus- tomer rents a video, the system must ensure that he or she does not have any overdue videos. If...

Create an Entity relationship diagram (ERD) conceptual model for this case. VINEYARD HOLDINGS AND GRAPE VARIETIES...

Create an Entity relationship diagram (ERD) conceptual model for this case. VINEYARD HOLDINGS AND GRAPE VARIETIES VVI’s vineyard sources its wine from ten plots of land in separate locations from two acres to twenty acres. Each vineyard has its own unique name, such as Rattlesnake Canyon, Red Fox, Theresa’s, etc. and is either owned by VVI or by an independent third party. Each is managed by a single employee. No employee manages more than one vineyard. The location and size,...

Develop a Entity-Relationship Diagram (ERD) Many-to-Many The city of Terra Haute, IN wants to maintain information...

Develop a Entity-Relationship Diagram (ERD) Many-to-Many The city of Terra Haute, IN wants to maintain information about its extensive system of high schools, including its teachers and their university degrees, its students, administrators, and the subjects that it teaches. Each school has a unique name, plus an address, telephone number, year built, and size in square feet. Students have a student number, name, home address, home telephone number, current grade, and age. Regarding a student’s school assignment, the school system...

5. Draw an entity-relationship diagram, including minimum and maximum cardinality, for the following: The system stores...

5. Draw an entity-relationship diagram, including minimum and maximum cardinality, for the following: The system stores information about two things: cars and owners. A car has attributes for make, model, and year. The owner has attributes for name and address. Assume that a car must be owned by one owner and an owner can own many cars, but an owner might not own any cars (perhaps she just sold them all, but you still want a record of her in...

(1) Draw the diagram showing the relationship between SAC and LAC. (2) Draw the diagram showing...

(1) Draw the diagram showing the relationship between SAC and LAC. (2) Draw the diagram showing the relationship between SMC and LMC.

SNOWMOBILE CLUB - Database Development Draw an Entity-Relationship Diagram which must include all entities and their...

SNOWMOBILE CLUB - Database Development Draw an Entity-Relationship Diagram which must include all entities and their attributes. Primary Keys underlined, Foreign Keys labeled, Weak entities double boxed. You have been asked to develop a database to help the Wisconsin Snowmobile Association track their club members. The following are the predefined business rules: 1) Snowmobile Clubs are tracked by Wisconsin county. 2) A club can be assigned to multiple counties. 3) Members can belong to one or more clubs. 4) Some...

Research and explain with your own words Chen’s entity-relationship data (ERD) model and the process of...

Research and explain with your own words Chen’s entity-relationship data (ERD) model and the process of normalization from first normal form to third normal form. Discuss what types of information are stored in your sector (or sector of interest) and what types of information are shared with a third party (if any).

Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent...

Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent the information requirements of company you are working for. You also need to write business rules and assumptions. Task 2: Create the Data Dictionary base on your ERD diagram.