ZuoTi.Pro
Question

6. The entity type STUDENT has the following attributes: Studen Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based su- dent activity, whereas No_of Years represents the number of years the student has engaged in this activity. A given stu- deni may engage in more than one activity. Draw an ERD for this situation.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

ER Diagram :

Age Phone No STUDENT Address Name Activity_History No_of_Years Activity

  • Here, combined Name and Phone_no attributes of the Student entity will act as the COMPOSITE Primary Key. In some cases Phone number is considered as multi-valued attribute but since it is not mentioned in your question I considered it as a single-valued attribute hence it is acting as a part of composite primary key.
  • Activity and No_of_Years attributes are acting as attributes of the multi-valued attribute(Activity_History) of the entity Student because every student has an activity in which he/she participated along with the no of years of engagement.
4 0
Add a comment
Know the answer?
Add Answer to:
6. The entity type STUDENT has the following attributes: Studen Name, Address, Phone, Age, Activity, and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s),...

    1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or...

  • Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information,...

    Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by...

  • The following are the main entity types of the academic institution database. For each entity type,...

    The following are the main entity types of the academic institution database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF,...

  • Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security...

    Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student&#39;s permanent address, and to the student&#39;s last name. Both social security number and student number have...

  • Implement an abstract class named Person and two subclasses named Student and Staff in Java. A person has a name, address, phone number and e-mail address. A student has a credit hour status (freshman...

    Implement an abstract class named Person and two subclasses named Student and Staff in Java. A person has a name, address, phone number and e-mail address. A student has a credit hour status (freshman, sophomore, junior, or senior). Define the possible status values using an enum. Staff has an office, salaray, and date-hired. Implement the above classes in Java. Provide Constructors for classes to initialize private variables. Getters and setters should only be provided if needed. Override the toString() method...

  • Identify all entity types, attributes, relationship types and their degrees in the following case Hence draw...

    Identify all entity types, attributes, relationship types and their degrees in the following case Hence draw an entity-relationship diagram An organization makes many models of cars where a model is characterized by a name and a suffix (such as GL or XL which indicates the degree of luxury) and an engine size. Each model is made up from many parts and each part may be used in the manufacture of more than one model. Each part has a description and...

  • Problem 1 Consider the following set of requirements for a university database that is used to...

    Problem 1 Consider the following set of requirements for a university database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, -, graduate), major department, minor department (if any), and degree program (B.A., B.S., ...., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...

  • 3 (16) You are hired to build a database for a local association of realtors. The database has to...

    3 (16) You are hired to build a database for a local association of realtors. The database has to contain information about the properties that are for sale in the area, realty agencies and agents, as well as keep track of the history of property sales. In particular, you are told the following about the desired database: o The database has to contain information about the realty agencies. Each agency has an ID, name, address and a phone number The...

  • 1. Draw an entity-relationship diagram that describes the following business environment. The city of Orlando, FL...

    1. Draw an entity-relationship diagram that describes the following business environment. The city of Orlando, FL 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...

  • Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...

    Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The ER diagram should include entities, attributes (if there are less than three specified in the business statements, please add some extra attributes), identifiers and corresponding data types, the relationships among entities with cardinality and associative entities. .b) Extend Q1.a) to apply generalization/specialization technique to construct an Enhanced-ER (EER) diagram. The EER diagram should specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT