2175forals.com215 home Data Modeling ERD reality Relationships qualities Example Draw.io software program Lab Assignment MySQL Account

Data Modeling

Data modeling is a an approach to document a software mechanism using diagrams and also symbols. The is supplied to represent communication of data.

The highest level that abstraction for the data version is referred to as the Entity partnership Diagram (ERD). That is a graphical depiction of data demands for a database.

You are watching: ____ describes how instances of one entity relate to instances of another entity.

Entity connection Diagram

The main value of very closely constructing one ERD is the it can readily it is in converted right into a database structure.

There space three contents in ERD.

Entities: variety of tables you need for her database. Attributes: information such as property, truth you require to define each table. Relationships: how tables are connected together.


Entities room the basic objects that ERDs. These space the tables of your database. Entity space nouns and also the varieties usually autumn into five classes: concepts, locations, roles, events or things. for example: students, courses, books, campus, employees, payment, projects. A particular example the an entity is referred to as an instance. Each circumstances becomes a document or a row in a table. For example: the student man Smith is a document in a table dubbed students.


Relationships are the associations in between the entities. Verbs often describe relationships in between entities. Us will use Crow"s Foot signs to represent the relationships. Three types of relationship are disputed in this lab. If you check out or hear cardinality ratios, it likewise refers to varieties of relationships.


One come One partnership (1:1)

A solitary entity circumstances in one entity class is related to a solitary entity instance in an additional entity class.

because that example: Each college student fills one seat and also one chair is assigned to just one student. each professor has one office space. One to countless Relationship (1:M)

A single entity circumstances in one entity class (parent) is related to multiple entity instances in another entity class (child)

for example: One instructor can teach countless courses, yet one course can only be taught by one instructor. One instructor may teach many students in one class, however all the students have actually one instructor for the class. plenty of to countless Relationship (M:M)

Each entity instance in one entity class is regarded multiple reality instances in another entity class; and vice versa.

for example: each student deserve to take countless classes, and each class can be taken by plenty of students. Each consumer can buy numerous products, and also each product have the right to be bought by many consumers.

The detailed Crow"s Foot partnership symbols deserve to be found here. Crow"s Foot connection Symbols

Many to countless relationships are difficult to represent. We should decompose a plenty of to numerous (M:M) relationship into two one-to-many (1:M) relationships.


Attributes room facts or description of entities. Castle are also often nouns and become the columns the the table. Because that example, for entity student, the qualities can be an initial name, critical name, email, address and phone numbers.

Primary crucial

Primary Key* or i would is one attribute or a set of features that uniquely identifies an instance of the entity. Because that example, for a college student entity, student number is the primary vital since no two students have the same student number. We can have only one primary crucial in a table. It recognize uniquely every row and also it can not be null. Foreign crucial A foreign key+ (sometimes referred to as a referencing key) is a vital used to attach two tables together. Frequently you take it the primary vital field native one table and also insert it right into the other table where it i do not care a foreign vital (it remains a primary an essential in the original table). We deserve to have an ext than one foreign key in a table.

An Example

Here"s a sample crowsfoot diagram indigenous a previous offering of 2175forals.com270 taught below at the university of Regina. We"ve redrawn the diagrams making use of more modern diagramming tools, however the contents is unchanged. It supplies a many ERD symbols, so you might want to usage Vivek Chawla"s quick guide while you review it.


Quick Questions

How many entities room there in this diagram and also what are they? over there are 7 entities: STUDENT, COURSE, INSTRUCTOR, SEAT, CLASS, SECTION and PROFESSOR. What space the qualities for entity STUDENT? The qualities for entity STUDENT are: student_id, student_name and also student_address What is the primary vital for STUDENT? The primary vital for student is: student_id What is the primary key for COURSE? no a cheat question! there is only one primary key, but it is comprised of two attributes. This is referred to as a compound key
. What foreign keys carry out STUDENT and also COURSE contain? STUDENT and also COURSE save no foreign keys in this diagram. This can suggest that there are troubles with the design... Amongst them is the plenty of to countless relationship here. This usually needs that we create a separate table to explain the relationship. This kind of table commonly connects international ids to each other. In this case, let"s add an entity called REGISTRATION in the center of the "takes" relationship. Due to the fact that students probably sit in different seats for each food they space registered in, lets relate chair to REGISTRATON instead of STUDENT:
The it is registered entity likewise uses a special instance of compound crucial that has compound foreign keys - it is a composite key
. .

ERD Tools

countless tools are available to aid you style Entity relationship Diagrams. Here is a short list of choices you could want come try. Visio ConceptDraw draw.io The registration redesign diagram was done through draw.io Draw.io is complimentary on-line diagramming software that can be linked to cloud drives favor Google Drive, OneDrive, DropBox and GitHub. When Draw.io web page is loaded, make sure to select Entity Relation on the left hand side. If you are lucky her lab instructor will carry out a demonstration... ;) come submit your completed ERD, fiddle it come PDF favor this: File->Export asPDF document.

lab Assignment


Create an appropriate Entity connection Diagram (ERD) for the data associated with an online application. This ERD should include the user accounts, posts and also re-posts entities. To obtain you started, you have the right to follow the instance given below.


User entity

The User entity collect attributes: user_id(*primary key), user_email, user_name, user_password user_DOB, User_image and etc.

post entity

The short article entity collect attributes: post_id(*primary key), user_id (+foreign key), post_detail, post_date, URL and also etc.

Re-post reality

What features should Re-post reality contain? Think that one or an ext things a repost can add to a post. Justification your design with a label.


The partnership shown in between user and post in our example is great enough. Add relationships in between Re-post and the various other two. Justification or describe your decision in text labels, and be sure you have selected compatible primary and also foreign keys. Because that example: A user may make countless posts, but each post was composed by only one user. We may search for the user_id in the write-ups to discover all the write-ups a user made.

Please export the paper as a PDF document.

Upload the ERD ~ above URcourses and administer a working connect to the ERD from her homepage before 11:55pm ~ above the job you take it this lab.

Be ready for following lab, obtain your MySQL account set up.

Marks will certainly be deducted if your MySQL account is not all set by following lab.

See more: Answered: Draw The Structure Of O-Chloroaniline., Télécharger Draw The Structure Of O

Creating a MySQL Account

For storing documents or data sets, the 2175forals.com215 labs use Hercules to work with a MySQL database. The adhering to provides accuse to create your very first MySQL database account.

click the "MySQL" attach


Login with your 2175forals.com username/ password


choose your MySQL password (must be different from your 2175forals.com password) Please make a note (on your phone or otherwise) that this password because you will be utilizing it in a later on lab If one account already exists, you deserve to reset or drop your database


it takes 5 to 30 minutes to develop a MySQL database.

©2014-2017 department of computer system Science, university of Regina