Database Design and Entity-Relationship Modeling notes
13 notes by 11 users
This GoConqr page gathers over 11 community-made resources on Database Design and Entity-Relationship Modeling notes: quizzes, mind maps, flashcards and notes to revise and practise with.
Notes
-
Untitled Master Detail Relationship:- This is parent-child relationship; Detail record must have Master record reference; The detail record inherits the sharing and security settings of its master record. Parent rec...
-
Relationships Relationships- Any significant association between two entities Relationships are always two-way Relationships have three characteristics/attributes Optionality - is or might be. Name Cardinality - one or ...
-
Data Normalisation Basics What is data normalisation?Is the process of organising the fields and tables of a relational database to minimize redundancy and dependency First Normal Form (1NF)For a database to be in first normal form (1NF), the ...
-
Domain 4-Maintain database- A Good Database Design Good database design is a process that involves a team of individuals who have good relational database knowledge and extensive technical database design expertise. In addition, the database development team needs to ...
-
How to normalise logical data models Do any attributes have multiple values for a single instance of an entity? 0. Unnormalised Form Yes - remove the repeating attributes and repeating groups. Create an entity that describes the attributes. Often you wil...
-
3. Let's Design a Database! 3. Lest's Design a Database! What is the E-R model? E-R (entity-relationship), try to define an entity in your data. Shows the relationship between entities The number of associations between entities is called ...
-
Users - created from Mind Map_1 Users Uid UName UToken Udevice AreaId CityId Status Warnings Wid Uid Title lati longi Date Time speedLimit Likes Dislikes camerType Showen(Bool) WLikers WLid Uid Wid
-
Users - created from Mind Map Users Uid UName UToken Udevice Warnings Warnings Wid Uid Title lati longi Date Time speedLimit Likes Dislikes camerType Showen(Bool)
-
Untitled Entities: User: Represents individuals who interact with the YouTube Music Library. Users have profiles containing information such as username, email,password... Attributes: User ID (primary key), Username, Email(pri...
-
Untitled Advantages of surrogate keys: applications cannot lose their reference to a row in the database the primary key data can always be modified, even with databases that don't support cascading updates across related fore...
-
Introduction NORMALIZATION: Process of splitting relations into well-structured relations hat allow users to operate on DB w/o introducing DB inconsistencies. ANOMALIES: Problems arising from relations that are generated directly ...
-
Lesson 3 ER DIAGRAM ERD is a pictorial representation of a database structure. Different shapes of items in the diagram represents different components of the database.
-
sys arch (models) - created from Mind Map accoun.invoice crm.account fields
More Database Design and Entity-Relationship Modeling resources
About database design and entity-relationship modeling notes
GoConqr OriginalDatabase Design and Entity-Relationship Modeling notes
These notes offer different ways into the unit. Data Normalisation Basics introduces normalisation and first normal form. Relationships describes associations between entities, including optionality and cardinality. Another note explains how an ER diagram represents database components.
How to use the notes
Start with Data Normalisation Basics if you want an introduction to organising fields and tables. Then read How to normalise logical data models for questions about attributes with multiple values and repeating groups.
As you read, write down terms you want to revisit, such as cardinality or surrogate keys. Compare your notes with the relevant resource, then explain each term in your own words. When you want to check your understanding, switch to a quiz on the unit page.
Choose a note that matches the topic you are studying today.
Frequently asked questions
Which note should I start with?
Start with Data Normalisation Basics if you are reviewing how fields and tables are organised. It introduces normalisation and first normal form. For entity relationships instead, Relationships describes associations between entities and introduces characteristics such as optionality and cardinality.
Are these notes free to use?
Yes. Every note listed on this page is free to open and study without an account. The notes were made by GoConqr users. A free account also lets you save quiz scores and create your own quizzes, mind maps, flashcards and notes.
Who are these notes for?
Most of the notes are at university level. University students can use them to review topics such as normalisation, relationships and ER diagrams. Teachers looking for material can browse the notes for explanations of these topics, including questions used to examine logical data models.