Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following three relations. Column domain specifications are omitted for brevity. TABLE account (act# ,branch# ,owner-s sn, TABLE checking(act#,branch#,fee, balance, PRIMARY KEY(act, branch#)); PRIMARY

image text in transcribed

Consider the following three relations. Column domain specifications are omitted for brevity. TABLE account (act# ,branch# ,owner-s sn, TABLE checking(act#,branch#,fee, balance, PRIMARY KEY(act, branch#)); PRIMARY FOREIGN KEY KEY (act, branch#), (act, branch#) REFERENCES account); TABLE savings(act, branch#, interest,minBalance, PRIMARY KEY (act#, branch) FOREIGN KEY (act#,branch#) REFERENCES account): Although not written above, you can assume that all foreign key constraints are followed by ON DELETE CASCADE and ON UPDATE CASCADE. ** One of the integrity constraints in this domain is that every account is either a savings or a checking account.** I. (a) Express this as a general SQL _assertion_ constraint. /* mySQL does not support constraint checking so you won't be able to test this * Consider the following three relations. Column domain specifications are omitted for brevity. TABLE account (act# ,branch# ,owner-s sn, TABLE checking(act#,branch#,fee, balance, PRIMARY KEY(act, branch#)); PRIMARY FOREIGN KEY KEY (act, branch#), (act, branch#) REFERENCES account); TABLE savings(act, branch#, interest,minBalance, PRIMARY KEY (act#, branch) FOREIGN KEY (act#,branch#) REFERENCES account): Although not written above, you can assume that all foreign key constraints are followed by ON DELETE CASCADE and ON UPDATE CASCADE. ** One of the integrity constraints in this domain is that every account is either a savings or a checking account.** I. (a) Express this as a general SQL _assertion_ constraint. /* mySQL does not support constraint checking so you won't be able to test this *

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

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

More Books

Students also viewed these Databases questions

Question

2. How will the team select a leader?

Answered: 1 week ago