here is an example:WORLD schema (complete)COUNTRY (Code, Name, Continent, Region, SurfaceArea, ... Code2)AK NameFK Capital References CITY, Nulls AllowedDelete Nullify, Update NullifyCITY ( ID, Name, CountryCode, District, Population)FK CountryCode References COUNTRY, Nulls Not AllowedDelete Cascade, Update CascadeCOUNTRYLANGUAGE( CountryCode, Language, IsOfficial, Percentage)FK CountryCode References COUNTRY, Nulls Not AllowedDelete Cascade, Update Cascade Complete the relational model design of the following scenario byproviding the appropriate attribute names for each table. Candidate keysand foreign keys must be depicted correctly in the schema. Take ascreenshot of your design along with the sample data for each table inone image.NOTES: Do NOT add any other tables other than the ones provided. Do NOT include the foreignkey rules, only the FK definitions. Provide sufficient sample data that demonstrate entity andreferential integrity..iFlex, a streaming service that monitors its subseribers by keeping track of the number of users for each plan.iFlex offers four plans namely mobile, basic, standard and premium. Each plan costs Php149 00, Php349.00,Php459 00 and Php549 00 respectively Subsenbers are requred to log in to the site by using their registeredemail addresses in order to search for and watch a particular film. It is important to monitor the subscriptiondate (for defining the billing cycle) Newly created subscriptions are considered active However, these mayalso be suspended, canceled or terminatedRelational SchemaUSERS (),PLAN (),SUBSCRIPTION ().

Answered: Image /qna-images/answer/b6eac602-c618-436a-b1f4-8db42475154a.jpg

Answered: here is an example: WORLD schema…

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

here is an example:

WORLD schema (complete)
COUNTRY (Code, Name, Continent, Region, SurfaceArea, ... Code2)
AK Name
FK Capital References CITY, Nulls Allowed
Delete Nullify, Update Nullify

CITY ( ID, Name, CountryCode, District, Population)
FK CountryCode References COUNTRY, Nulls Not Allowed
Delete Cascade, Update Cascade

COUNTRYLANGUAGE( CountryCode, Language, IsOfficial, Percentage)
FK CountryCode References COUNTRY, Nulls Not Allowed
Delete Cascade, Update Cascade

Complete the relational model design of the following scenario by
providing the appropriate attribute names for each table. Candidate keys
and foreign keys must be depicted correctly in the schema. Take a
screenshot of your design along with the sample data for each table in
one image.
NOTES: Do NOT add any other tables other than the ones provided. Do NOT include the foreign
key rules, only the FK definitions. Provide sufficient sample data that demonstrate entity and
referential integrity..
iFlex, a streaming service that monitors its subseribers by keeping track of the number of users for each plan.
iFlex offers four plans namely mobile, basic, standard and premium. Each plan costs Php149 00, Php349.00,
Php459 00 and Php549 00 respectively Subsenbers are requred to log in to the site by using their registered
email addresses in order to search for and watch a particular film. It is important to monitor the subscription
date (for defining the billing cycle) Newly created subscriptions are considered active However, these may
also be suspended, canceled or terminated
Relational Schema
USERS (),
PLAN (),
SUBSCRIPTION ().

Expert Solution

Step by step

Solved in 2 steps with 1 images

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