Ask a Question
  
  
  
Top Posters
Since Sunday
208
110
25
24
22
22
21
21
21
20
20
19
New Topic  
wrote...
Posts: 30
Rep: 5 0
4 days ago
What are supertype and subtype entities? Include an example.
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 2 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 25
Rep: 3 0
4 days ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
When instances of an entity can be categorized into different types with each type sharing some common characteristics while having certain characteristics that are unique to each type, the common attributes can be separated from the unique ones. This is represented in E-R diagrams through the use of supertype and subtype entities. The supertype entity class contains the attributes that are common to all of the subtypes. The subtype entity classes represent the different types, or categories, of the supertype. Only the attributes that are unique to a given subtype tend to be listed as the attributes of that subtype. Each subtype has a relationship with the supertype. All subtypes should have the same identifier as the supertype since they represent different perspectives of the same thing. As an example, consider VEHICLE (VIN, year, make) as a supertype, with subtypes CAR (VIN, model, seatingCapacity) and MOTORCYCLE (VIN, horsepower). All vehicles have VINs, a year, and a make. CARs additionally have a model and a seating capacity and MOTORCYCLES additionally have a horsepower rating.
This verified answer contains over 180 words.
1
wrote...
4 days ago
Smart ... Thanks!
New Topic      
Share This Topic
Similar topics that might interest you...
Computer Studies   2 years ago   Raspberry   dorkalot   3 Replies   83 Views
Computer Studies   2 years ago   Raspberry   dorkalot   3 Replies   84 Views
Computer Studies   2 years ago   Raspberry   dorkalot   3 Replies   70 Views
Computer Studies   4 days ago   banggedung   DWFG2796   1 Reply   2 Views
4 More
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  71 People Browsing
 116 Signed Up Today
Related Images
 800
 388
 55
Your Opinion
What percentage of nature vs. nurture dictates human intelligence?
Votes: 61