question

mcdani41 avatar image
mcdani41 asked

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. 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
sqloraclehomework
djs-on-demand-erd.pdf (204.1 KiB)
1 comment
10 |1200

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

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 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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