Reverse Engineer Database into Model

MySQL Database Development Mastery Manipulating Tables and Data - CRUD Operations
6 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€67.28
List Price:  €96.12
You save:  €28.84
£55.84
List Price:  £79.78
You save:  £23.93
CA$100.66
List Price:  CA$143.81
You save:  CA$43.15
A$112.30
List Price:  A$160.44
You save:  A$48.13
S$95.06
List Price:  S$135.81
You save:  S$40.74
HK$543.65
List Price:  HK$776.68
You save:  HK$233.03
CHF 62.95
List Price:  CHF 89.94
You save:  CHF 26.98
NOK kr796.08
List Price:  NOK kr1,137.30
You save:  NOK kr341.22
DKK kr501.96
List Price:  DKK kr717.11
You save:  DKK kr215.15
NZ$124.09
List Price:  NZ$177.29
You save:  NZ$53.19
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.19
৳8,350.53
List Price:  ৳11,929.84
You save:  ৳3,579.31
₹5,966.48
List Price:  ₹8,523.91
You save:  ₹2,557.43
RM312.78
List Price:  RM446.85
You save:  RM134.07
₦108,176.54
List Price:  ₦154,544.54
You save:  ₦46,368
₨19,454.09
List Price:  ₨27,792.76
You save:  ₨8,338.66
฿2,392.25
List Price:  ฿3,417.65
You save:  ฿1,025.40
₺2,467.97
List Price:  ₺3,525.82
You save:  ₺1,057.85
B$472.19
List Price:  B$674.59
You save:  B$202.39
R1,303.83
List Price:  R1,862.70
You save:  R558.86
Лв131.65
List Price:  Лв188.08
You save:  Лв56.43
₩102,536.89
List Price:  ₩146,487.56
You save:  ₩43,950.66
₪256.46
List Price:  ₪366.39
You save:  ₪109.93
₱4,057
List Price:  ₱5,795.97
You save:  ₱1,738.96
¥11,019.26
List Price:  ¥15,742.47
You save:  ¥4,723.21
MX$1,411.83
List Price:  MX$2,016.98
You save:  MX$605.15
QR254.14
List Price:  QR363.08
You save:  QR108.93
P970.50
List Price:  P1,386.50
You save:  P415.99
KSh9,031.50
List Price:  KSh12,902.70
You save:  KSh3,871.20
E£3,562.42
List Price:  E£5,089.40
You save:  E£1,526.97
ብር8,897.26
List Price:  ብር12,710.92
You save:  ብር3,813.65
Kz63,830.88
List Price:  Kz91,190.88
You save:  Kz27,360
CLP$69,297.02
List Price:  CLP$99,000
You save:  CLP$29,702.97
CN¥510.85
List Price:  CN¥729.81
You save:  CN¥218.96
RD$4,256.60
List Price:  RD$6,081.12
You save:  RD$1,824.52
DA9,464.46
List Price:  DA13,521.24
You save:  DA4,056.78
FJ$162.28
List Price:  FJ$231.84
You save:  FJ$69.55
Q538.26
List Price:  Q768.97
You save:  Q230.71
GY$14,619.81
List Price:  GY$20,886.35
You save:  GY$6,266.53
ISK kr9,762.20
List Price:  ISK kr13,946.60
You save:  ISK kr4,184.40
DH704.68
List Price:  DH1,006.73
You save:  DH302.05
L1,286.35
List Price:  L1,837.72
You save:  L551.37
ден4,141.74
List Price:  ден5,917.03
You save:  ден1,775.28
MOP$559.01
List Price:  MOP$798.63
You save:  MOP$239.61
N$1,299.34
List Price:  N$1,856.28
You save:  N$556.93
C$2,571.30
List Price:  C$3,673.45
You save:  C$1,102.14
रु9,517.06
List Price:  रु13,596.38
You save:  रु4,079.32
S/260.20
List Price:  S/371.74
You save:  S/111.53
K283.61
List Price:  K405.18
You save:  K121.56
SAR262.77
List Price:  SAR375.40
You save:  SAR112.63
ZK1,933.89
List Price:  ZK2,762.82
You save:  ZK828.92
L334.80
List Price:  L478.31
You save:  L143.50
Kč1,689.59
List Price:  Kč2,413.80
You save:  Kč724.21
Ft27,569.95
List Price:  Ft39,387.34
You save:  Ft11,817.38
SEK kr774.42
List Price:  SEK kr1,106.36
You save:  SEK kr331.94
ARS$71,763.27
List Price:  ARS$102,523.35
You save:  ARS$30,760.08
Bs482.86
List Price:  Bs689.84
You save:  Bs206.97
COP$309,145.61
List Price:  COP$441,655.52
You save:  COP$132,509.90
₡35,480.70
List Price:  ₡50,688.88
You save:  ₡15,208.18
L1,775.44
List Price:  L2,536.46
You save:  L761.01
₲544,980.94
List Price:  ₲778,577.57
You save:  ₲233,596.63
$U3,110.44
List Price:  $U4,443.67
You save:  $U1,333.23
zł287
List Price:  zł410.02
You save:  zł123.01
Already have an account? Log In

Transcript

Hey guys in this lesson, we will start looking at how we can go over reverse engineering our newly created database into a database model. Now a database model is a graphical representation of our tables and how they relate to each other in database development, terminologies really referred to as an entity relationship diagram or er D for short, or ER diagram, all of those are pretty much the same thing. And what you're seeing on screen here is an ER diagram that was generated based on one of the sample of this database is called World Alright, so this is essentially a graphical representation, like I said, off the database, meaning you print this out on a piece of paper and you hand it to somebody they should be able to clearly identify your table which is which is represented by this box here. And it's also called an entity so table and the entity are pretty much used interchangeably.

So the entity is city. And each line in this box represents the columns. And then you'll see that there's this highlighting thing that's going on here. And this line connecting city to country and also line connecting country language to country. So later in the lesson we will get into that those are called relationships, which is why the R means entity relationship diagram. So it shows the relationships between the tables.

We don't have any relationships in a school DB just yet. But we will be looking at how we can go about having already created our database using scripts reverse engineer into model looking form. So we're back on our home screen for my SQL workbench. In just opened it we land on this screen, and there are two avenues to get to this data modeling interface. So one, we can go ahead and create on a tour instance, like we would on a normal circumstances, and here I have all of the script files. So if you have closed the workbench and reopen, did you notice that it kind of keeps track of all the scripts that you would have been working on.

But that's besides the point. To get started with this reverse engineering, you could just go to database and then you see the option there that says reverse engineer. Alternatively, without even connecting to the instance, you could just go to this modeling this er D looking icon to the left, which is underneath that dolphin, right? And then you could go ahead and just click this arrow and then it will say create ER model from database. So either one of those ways can get you started. You also have that database option up here, reverse engineer, so any way you take it, it will be the same results.

So I just go ahead and click reverse engineer up here, and they both will launch this To this dialog, which will ask you to select an instance to connect to maybe yours would would have started off blank. So you can just click that. And you can just choose the default local instance that you would have been using to connect up to now, and everything would have been filled in, you click next, and then it will do some checks. And then it will ask you which one of these schemas Do you want to include? So you can do multiple schemas at a time. Or no, we're just focusing on the one that we're creating.

So I'll just click school dB, and click Next. There are some checks click Next. And then it will ask us what objects do we want to import. So the CRD actually will import all the tables, all the views, all the function and stored procedures that are in your database in total, so right now we only have some tables, which are courses, lecturers and students and by default, the tables will be included. Alright, so we can just go ahead and click Execute. So they say that the three are selected.

If you want to deselect or not choose one, you can just click it and click that arrow and it will bring it over. So it will know that three are in total. And two have been selected for the modeling exercise. But I want all three in the modeling exercise, so I'll just leave that as it is. And then I'll go ahead and click Execute. And then this will do something in the background, which I really want to see.

So I just click next, and get rid of this on the screen by clicking finish. And I see here that Okay, I have one table somewhere, and then you can have a visual cue as to where your tables are on the sheet of paper. So as you scroll down, you'll see that the next one is there and as you move it, the visual cue is updating. So I want to see all three of them beside each other. So I just dragged all of them up to the top. And you would notice once again that we have no lines because we haven't established any relationships between our tables.

Just yet, we will get there. But I just really wanted to show you that my SQL workbench makes it easy that having created the database, if your supervisor wants to see it on paper, you know, he doesn't want to go into the database and log in to see Oh, you did this and that how what are the rules. So this is a nice easy way to just represent your database that your supervisor who might be it savvy, or your manager who might not be it so we can have an appreciation for your database design and all the entities and the columns or data points that you are storing per entity. Also, you would notice that the icons are there representing the primary keys and they are color coded according to when we were initially designing this database. So we can have some visual cues as to what is nullable and what is not.

Now the cool thing about this is that you can also make changes here you can actually add a new table on to this onto this sheet right here. So I can just say table one. And I can start putting in all the columns just like we did when we're designing or tables. Using the workbench interface, we can make all those modifications, and then effect those changes in the database. So you have some people who aren't so first on using the script to design their database. So they rely on the data data modeling tool, provided by workbench, which allows them to just click and put in the data and then have this visual representation, and then the generate the database from the already generated model.

In this case, we already built our database and now we're just looking at the model for it. But later on in this lesson, we will be looking at how we can go about generating the database from a model that is designed in this interface.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.