M
M
Michael Vasyukov2017-10-17 18:51:22
Database
Michael Vasyukov, 2017-10-17 18:51:22

How to create a database based on the ER model?

Hello, dear toasters =)
I have a question about one task. (I searched the Internet, I didn’t find anything normal)
So, they gave me the following task: Create a database based on the ER model given to you. Import or enter existing data into the database.
The ER model itself: 59e6259eeddca920786163.png
A folder came with it, it contains 10 xlsx files: 59e625e70d383361502205.png
I think this applies to this task.
So, the question is:
1) Why is PK after the table name in the ER model?
2) Which way to stomp to build/create a database based on ER models?
PS Thank you very much! Thank you! =)

Answer the question

In order to leave comments, you need to log in

3 answer(s)
D
Denis Holub, 2017-10-17
@programmer_developer

And what's in the files of these Ekselevsky? The names of the files are comparable to the names of the tables.
As I see it:
1. PK says that this table will have a primary key.
Table attributes must be specified in Excel files with the same name as the table.
2. I think it will be the same time to create tables and links by hand as to draw this model somewhere else.

A
Astrohas, 2017-10-17
@Astrohas

I can be wrong, but in vizhe there is the possibility of creating schemes with a bear

A
Andrey Skorzhinsky, 2017-10-18
@AndyKorg

1 Download ErWin
2 Draw (or open if there is a file with a model) Er-model in it
3 Unload scripts from ErWin
4 Create database scripts on the server
5 Profit!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question