COMP 3380 Lecture 2: Week_2_ER_model

8 views5 pages

Document Summary

Week 2 er model entity set - a database at a certain time. Attributes entity types have schema schema which attributes entities in the set must have ( data model ) Entities is called a tuple ( entry in a db ) Attributes in an entity have domain of permitted values. Permitted values are a domain (sometimes called value set) for e. g. ages are positives. All squared are positive fixed length student id number. Entity is the object in the universe of discourse ( mini world representation ) Attributes of the entity is some information of the entity. Simple/atomic attributes can not be broken up a number. Composite attributes can be broken down into multiple attributes multivalued attributes list of attributes ( doubly lined oval in er diagram ) Derived attribute attribute that is calculated when a view is created. Week 2 er model2 multivalued attributes course # grade term gpa derived attribute.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions