SMG IS 223 Lecture Notes - Lecture 13: Foreign Key, Unique Key, Scalability
• Entity- labeled with nouns and singular
• Attributes-inside container
• 2 Entities having relationship- cardinalities
• Max to min or min to max? Min to max
• Join 2 tables
• Primary key turns into foreign key in another table
• Database Fundamentals
• Data is everywhere in an organization
• Employees must be able to collect, compile, sort, query and analyze the data in many
different ways to assist in making decisions
• Purpose of a database – to keep track of data/information in an organized fashion to
allow for interaction
• Row on access represents a record
• Why Databases?
• Flexibility
• Scalability and performance
• Reduced information redundancy (repeat info)
• Increased info integrity (quality)
• Increased info security
• Simultaneous access
• What you Can See Within an Organization
• Read- can read document
• Write- allow you access to write
• Modify- can limit
• Users of Databases
• Database administrators
• Programmers
find more resources at oneclass.com
find more resources at oneclass.com