Scribd Logo
Upload

Welcome to Scribd!

  • 35 views

    7 Web PDF

    Uploaded by

    Koetlisi Makhaola Elliott Theko
    This document provides a database schema for an online digital media store with tables for artists, albums, tracks, invoices, customers, playlists, and employees. The schema tracks information about artists and albums, media tracks including format, genre and playlist inclusion. It also includes tables to track customer invoices and orders, employee reporting structure, and the relationship between customers and their support representatives.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    7 Web PDF

    Uploaded by

    Koetlisi Makhaola Elliott Theko
    35 views2 pages
    This document provides a database schema for an online digital media store with tables for artists, albums, tracks, invoices, customers, playlists, and employees. The schema tracks information about artists and albums, media tracks including format, genre and playlist inclusion. It also includes tables to track customer invoices and orders, employee reporting structure, and the relationship between customers and their support representatives.

    Original Description:

    mine

    Original Title

    7-web.pdf (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a database schema for an online digital media store with tables for artists, albums, tracks, invoices, customers, playlists, and employees. The schema tracks information about artists and albums, media tracks including format, genre and playlist inclusion. It also includes tables to track customer invoices and orders, employee reporting structure, and the relationship between customers and their support representatives.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    35 views2 pages

    7 Web PDF

    Uploaded by

    Koetlisi Makhaola Elliott Theko
    This document provides a database schema for an online digital media store with tables for artists, albums, tracks, invoices, customers, playlists, and employees. The schema tracks information about artists and albums, media tracks including format, genre and playlist inclusion. It also includes tables to track customer invoices and orders, employee reporting structure, and the relationship between customers and their support representatives.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    CS 3432 – PRINCIPLES OF DATABASE DESIGN AND DATA MANAGEMENT

    PRACTICAL TEST
    DATE: 24-APR-2019 DURATION: 1 HR
    MARKS:

    A Schema for an online digital media store.

    Below is a database diagram for an online video and music store, including tables for artists,
    albums, media tracks, invoices and customers. The business rules incorporated in the
    database design include the following:
     Each track is stored using one of the digital formats (MediaType) and has a genre.
     Each track belongs to an album, which is released by a particular artist.
     The store has some playlists, where a single track can be part of several playlists.
     Orders are recorded for customers, but are called invoices.
     Every customer is assigned a support employee, and Employees report to other
    employees.
    Playlist
    PlaylistId
    Track
    Name
    TrackId
    Album
    AlbumId Name

    Title AlbumId

    ArtistId MediaTypeId
    GenreId PlaylistTrack
    PlaylistId
    Composer
    TrackId
    Milliseconds
    Bytes
    UnitPrice
    Artist
    ArtistId MediaType
    MediaTypeId
    Name
    Name

    InvoiceLine
    Invoice InvoiceLineId
    InvoiceId
    InvoiceId Genre
    CustomerId GenreId
    TrackId
    InvoiceDate Name
    UnitPrice
    BillingAddress
    Quantity
    BillingCity
    BillingState
    BillingCountry
    BillingPostalCode
    Total
    Customer
    Employee
    CustomerId
    EmployeeId
    FirstName
    LastName
    LastName
    FirstName
    Company
    Title
    Address
    ReportsTo
    City
    BirthDate
    State
    HireDate
    Country
    Address
    PostalCode
    City
    Phone
    State
    Fax
    Country
    Email
    PostalCode
    SupportRepId
    Phone
    Fax
    Email

    You might also like