Can someone help me with this database question? I have attached all the files below.

djs-on-demand-erd.pdf

Create the following tables, columns, and datatypes according to the diagram based on the physical diagram on page 2 of the file DJs_on_Demand_ERD

You do not need to create any primary keys or foreign keys; however, you will need to set the columns identified with a red asterisk (*).

NOT NULL. The PK and FK constraints will be added in a later assignment. It is VERY IMPORTANT that you name the tables and columns exactly as shown in the ERD. Failure to do so will cause future assignment to not work correctly.

Each table script is worth 4 points for a total of 48 points.

1. 1. d_track_listings
  2. d_play_list_items
  3. d_songs
  4. d_types
  5. d_job_assignments
  6. d_partners
  7. d_events
  8. d_venues
  9. d_themes
  10. d_packages
  11. d_clients
  12. d_cds

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green commented · Feb 03, 2020 at 08:29 AM

What part of this are you struggling with?

As this mentions "assignments" we will be reluctant to give you the answer without showing what you have tried already and what bits you are stuck on.

Firstly I would look at the syntax for CREATE TABLE

0 ·