All Questions
4 questions
0
votes
1
answer
620
views
Designing User & its Sub User Database Diagram Problem [duplicate]
There are some business category e.g. Travel Agency, Hotel, Car Rental etc.
Roles:
Management rolesSuper Admin, Staff
Customer side roles are Owner, admin and sales counter
May be etc. customer side ...
- 5
0
votes
1
answer
63
views
Normalizing data for joins, dedicated columns, a view or.. something else? [closed]
As an example, i have the following tables
USERS, USER_JOBS and USER_HOUSES
USER_JOBS keeps a list of jobs for a given user_id
USER_HOUSES keeps a list of houses for a given user_id
the common use ...
- 9
6
votes
8
answers
63k
views
How to export an ER diagram from an Oracle DB? [closed]
I am developing this application with an Oracle database. I haven't been documenting the data model, but now an auditor wants to have an entity relationship diagram of my database. There are many ...
- 1,285
9
votes
1
answer
30k
views
How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?
I have an Oracle database, and I would like to create an ERD in Visio 2007 Pro.
I have so far looked at DBMS_METADATA.GET_DDL commands to generate DDL. I know that I can import an Access DB into ...
kg.