LW-01. Creation ER Diagrams with Online Case Tools - Lab Assignment - Solution

Oct 26, 2026

Lab material LW-01 guides building an ER diagram for an individual subject area variant. It explains how to compute the variant number from the student name using alphabet ordinals and a modulo-23 rule, then requests a short subject area description plus clear assumptions and restrictions. The solution requires creating a Chen notation ERD in App.diagrams.net and a Crow’s Foot ERD in Lucid.co, including many-to-many transformation into an associative entity, exporting PNGs, and adding publish/share links. It also requires writing the database scheme in text notation, defining domains, null rules, and keys, then assembling the lab report and submitting according to grading.

LanguageEnglish

CategoryTechnology

FormatPDF

Pages17

Reading Time43 min

AccessFree to download

Lab Target

Learn ERD notations with varying detail

Use cloud-based CASE tools: App.diagrams.net and Lucid.co

Lab Assignment

Select individual variant NR.

Insert variant subject area description

Describe assumptions and restrictions

Create Basic Concept Model (Chen notation)

Create Keys Concept Model (Crow’s Foot notation)

Publish links to ERD

Create database scheme on text notation

Lab Report

Report blank form requirements

Graduation

Grade on 10 points

Lab Guidelines

LW-01. CREATION ER DIAGRAMS WITH ONLINE CASE TOOLS. 1. LAB TARGET. 1.1. Learn to build ERD in various notations and with varying degrees of detail of the database model. 1.2. Gain practical experience using modern cloud-based CASE-tools App.diagrams. net and [Lucid.co](Lucid.co) 2. LAB ASSIGNMENT. 2.0. SELECT YOUR INDIVIDUAL VARIANT NR. 2.0.1. Calculate your variant of Subject Area. a) Write your LastName in English alphabet. Must be at least 6 letters, if not enough, then add the required number of letters from the FirstName (if not enough, then repeat LastName and FirstName) . For example, for student Yuriy Li there will be LIYURIY. b) Replace the first 6 letters with their ordinal numbers in the alphabet, writing the numbers as two-digit decimal numbers. For example, 12 09 25 21 18 09. c) Consistently add modulo 23 these 6 numbers and add 1 For example,(12+09+25+21 +18+09)mod23 + 1 = 94mod23 + 1 = 2 +1 = 3. d) The resulting will be your variant Nr. For example, 3. See assignment variant bellow in this document. 2.2. SOLUTION 2.2.1. INSERT YOUR VARIANT SUBJECT AREA DESCRIPTION (TASK TEXT) . 2.2.2. DESCRIBE ANY ASSUMPTIONS AND RESTRICTIONS THEN YOU MAKE ON YOUR VARIANT OF ENTERPRISE INFORMATION. 2.2.3. CREATE BASIC CONCEPT MODEL AS ERD ON CHEN’S NOTATION WITH APP. DIAGRAMS. NET SITE. 2.2.3.1. Register on [Draw.io](Draw.io) site ( [https://app.diagrams.net/](https://app.diagrams.net/)) . 2.2.3.2. Create ERD Chen’s notation, show entity names, primary keys, attributes, relationships and cardinality. 2.2.3.3. Export ERD to PNG and insert picture to your Report (File/Export as/PNG…) . 2.2.4. CREATE KEYS CONCEPT MODEL AS ERD ON CROW’S FOOT NOTATION WITH LUCID.CO SITE. 2.2.4.1. Register on Lucid.co site ([https://www.lucid.co/](https://www.lucid.co/)) . 2.2.4.2. Create ERD Crow’s Foot notation, show entity names, primary keys, foreign keys, attributes, relationships and cardinality. 2.2.4.3. Transform many-to-many relationship (m:n) to new Associative Entity. 2.2.4.4. If you think the ERD is incomplete, list other data the database should store & adjust your design to incorporate these additions. 2.2.4.5. Export ERD to PNG and insert picture to your Report ( Menu/Export/PNG…) . 2.2.5. MAKE A PUBLISH LINK TO ERD AND INSERT LINK-CODE TO YOUR REPORT. 2.2.5.1. Make a Publish Link to ERD [for App.diagrams.net](for App.diagrams.net) ( File/Publish/Link…- Include a copy of my diagram/Create/Copy) . 2.2.5.2. Make a Publish Link to ERD for [Lucid.co](Lucid.co) ( Menu/Share/Shareable link-On; Any logged in user-View) . 2.2.6. CREATE DATABASE SCHEME ON TEXT NOTATION. 2.2.6.1. Show entity names, attributes, primary keys, foreign keys, for each entity. 2.2.6.2. For each attribute, determine its domain of values, whether Null is an acceptable value, and, if acceptable, what Null indicates. 3. LAB REPORT. 3.1. REPORT BLANK. The report is provided electronic form with Report Blank Form (docx) . The report includes: 1. Description of the Your Subject Area variant. 2. Assumptions and restrictions. 3. Basic Concept Model. ERD on Chen’s [notation with](notation with App.diagrams.net)[ App.diagrams.net](notation with App.diagrams.net) site. 4. Keys Concept Model. ERD on Crow’s Foot notation with [Lucid.co](Lucid.co) site. 5. Publish Links to ERD. a) Link to [ERD for](ERD for App.diagrams.net)[ App.diagrams.net](ERD for App.diagrams.net) site. b) Link to ERD for [Lucid.co](Lucid.co) site. 6. Databases Scheme on text notation. 3.2. GRADUATION. Grade on 10 points: correctly make of all points. 4. LAB GUIDELINES. 4.1. REGISTER ON APP. DIAGRAMS. NET SITE | 4.1.1. Go to the [https://app.diagrams.net/](https://app.diagrams.net/ page)[ page](https://app.diagrams.net/ page). Select place of diagram saving: Device.
| 4.1.2. Select Create New Diagram (or Open Existing Diagram)
| | --- | --- | | 4.1.3.a. Select Template
Basic à Entity Relationship Diag

FAQs

How is the individual variant number calculated for the lab assignment?

Write the last name (minimum 6 letters, extend using first name if needed), replace the first 6 letters with their two-digit alphabet ordinals, then sum them and apply modulo 23, finally adding 1. The resulting value is the variant number.

What must be included in the Chen notation ERD created with App.diagrams.net?

Show entity names, primary keys, attributes, relationships, and cardinality in Chen’s notation. Export the diagram to PNG and insert it into the report.

How should a many-to-many relationship be handled in the Crow’s Foot model on Lucid.co?

Transform the many-to-many (m:n) relationship into a new associative entity, then include entity names, primary keys, foreign keys, attributes, relationships, and cardinality. Export to PNG and add the appropriate publish/share link to the report.

Oct 26, 2026

Upload by naya.afterrain