Answered: explain the erd diagram.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

explain the erd diagram. ( dont use ai tool)

Transcribed Image Text:SUBSCRIPTION PLAN PK PLAN ID Type PLAN_NAME Type MONTHLY_PRICE Type NO._OF_PROFILES Type DEVICES Type NO. OF SCREENS Type VIDEO QUALITY Type PLAN RESOLUTION Type USER PK CHAR(4) VARCHAR(25) VARCHAR(50) VARCHAR(50) USER PASSWORD VARCHAR(15) PHONE NUMBER CHAR(10) FK PAY_ID FK PLAN_ID USER_ID USER_FNAME USER_LNAME USER_EMAIL PROFILE PK PROFILE ID FK USER_ID PROFILE NAME FK FILM ID FK SERIES ID FILM PK FILM ID FK FILM TITLE Type Type CHAR(1) CHAR(4) VARCHAR(45) H CHAR(4) CHAR(4) CHAR(4) CHAR(4) CHAR(4) FK GENRE Key FILM DURATION Type Key Field Type Key AGE_CATEGORY Type Key FILM_DESCRIPTION Type Key FIELD Type Key ACTOR Type Key COUNTRY Type PAYMENT METHOD PK PAY_ID FK CARD_ID FK WALLET_ID CREDIT OR DEBIT CARD PK CARD_ID CHAR(4) VARCHAR(16) VARCHAR(5) VARCHAR(3) VARCHAR(255) OWNER LASTNAME VARCHAR(255) CHAR(1) CARD_NUMBER EXPIRATION_DATE CCV OWNER_NAME FK PLAN_ID SERIES PK CARD ID CARD NUMBER EXPIRATION_DATE CHAR(4) CHAR(4) CHAR(4) CCV OWNER NAME OWNER LASTNAME FK PLAN ID Key Field Key Field Key Field Key Field CHAR(4) VARCHAR(16) VARCHAR(5) VARCHAR(3) VARCHAR(255) VARCHAR(255) CHAR(1) Type Type Type Type DIGITAL WALLET OR MOBILE BILL PK WALLET ID MOBILE NUMBER FK PLAN ID EPISODES PK EPISODES ID EPISODE_TITLE CHAR(4) CHAR(4) CHAR(4) FK SEASON Key EPISODE DESCRI Key NO. OF EPISODES Key SERIES ID Key EPISODE_DURATION CHAR(4) CHAR(4) CHAR(4) Type Type Type Type

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions