Answer the question
In order to leave comments, you need to log in
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:
A folder came with it, it contains 10 xlsx files:
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
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.
I can be wrong, but in vizhe there is the possibility of creating schemes with a bear
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 questionAsk a Question
731 491 924 answers to any question