Question

1. How to generate database diagram for a database that stores information about the downloads that users make.

Each user must have an email address, first name, and last name.

Each user can have one or more downloads.

Each download must have a filename and download date/time.

Note: I want steps on how to generate this diagram using oracle SQL developer

Each product can be related to one or more downloads.

Each product must have a name.

Answer 1

Once you create your database schema and create new tables for User, Product and Downloads the follow below steps to generate database diagram using Oacle SQL developer.

create table Users(
    first_name varchar(50),
    last_name varchar(50),
    email_address varchar(50) primary key
);

create table product(
    product_name varchar(50) primary key
);

create table downloads(
    filename varchar(50),
    date_time TIMESTAMP (2) NOT NULL,
    constraint filenamefk foreign key (filename) REFERENCES product(product_name),
    email_address varchar(50),
    constraint email_addressfk foreign key (email_address)  REFERENCES users(email_address)
);

Create a diagram for existing database schema or its subset as follows:

1. Click File → Data Modeler → Import → Data Dictionary.
2. Select a DB connection (add one if none).
3. Click Next.
4. Check one or more schema names.
5. Click Next.
6. Check one or more objects to import.
7. Click Next.
8. Click Finish.

The ERD is displayed.

Export the diagram as follows:

1. Click File → Data Modeler → Print Diagram → To Image File.
2. Browse to and select the export file location.
3. Click Save.

Diagram: