Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider a Schema of relation S S (A:number, B:string, C:string, D:number, E:string) Below also shows you a valid instance of the relation S AB 2

image text in transcribed

image text in transcribed

Consider a Schema of relation S S (A:number, B:string, C:string, D:number, E:string) Below also shows you a valid instance of the relation S AB 2 4 Ann Bob Bob Kate Jim 18 20 18 (1a) (10 points) Given a create table statement below for relation S create table s A number, B number unique, C char (3) D number not null, E varchar (1) unique (B, D) Is this a correct or incorrect statement to make the above instance of S valid? List three (3) evidences that support your conclusion (very briefly explain why) Tips: Think about concepts and usages of primary key, unique, not null etc. (1b) (15 points) Consider the same Schema of relation S, now write a create table statement, which would make the instance of the relation S valid For your choice of primary key in your statement (which first of all has to be a candidate key), write just TWO (2) superkeys (not all) for that primary key Tips: Be careful the choice of primary key should not violate the minimal principle

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Database Programming

Authors: Chris Fehily

1st Edition

1937842312, 978-1937842314

More Books

Students also viewed these Databases questions

Question

Let Y 1 Answered: 1 week ago

Answered: 1 week ago

Question

2. Identify the call to adventure in Rocky.

Answered: 1 week ago

Question

O/R P : . { [ F 10 z } ] ENTER J SHIFT 4 APGUP

Answered: 1 week ago