From the course: Relational Databases Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Design a table
- [Instructor] Drawing a table in an entity relationship diagram is pretty straight forward. They're usually represented by a box with the table name here at the top. And then another box below with a list of the different columns that'll make up the table's structure. Here in the Quick Database Diagrams tool, I'm going to select all the placeholder demo text that appears on the left-hand side of the screen. Then I'm just going to simply delete it to give myself a blank slate. Now we can use this blank canvas to develop our own diagram. I want to create a database for storing information about the products sold by my company. I'll start by creating a table called "Products." (keys clicking) As soon as I type the name of the table in, you'll see a new table diagram element appear over here on the right. You can click and drag it around the screen if you want to move it into a new position. Now in this diagramming…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.