Use at least two queries to demonstrate that referential integrity is set up cor
ID: 3907006 • Letter: U
Question
Use at least two queries to demonstrate that referential integrity is set up correctly for your tables IN MS SQL
TABLE- Create table Membress
(
MemberId INT primary key
Firstname varchar (20),
Lastname varchar (20),
Phonenumber INT ,
Address varchar (30),
Memberpaymentmode INT,
Memberawardedhours INT,
Memberpayment type varchar (20),
);
Insert into Membress Values ('1','Amy','Jhonson','7709123033','109 Harbinsrd','Basic','40','Credit Card');
Table 2
Create Table Scheduleds (MemberId INT ,AirplaneId INT,Memberpaymentmode Varchar (20),Memberawrdhours INT,Usedhours INT);
Insert into Table Values ('1','01','Basic','40','17');
Explanation / Answer
If you have any doubts, please give me comment...
Create table Membress(
MemberId INT primary key,
Firstname varchar(20),
Lastname varchar(20),
Phonenumber INT,
Address varchar(30),
Memberpaymentmode INT,
Memberawardedhours INT,
Memberpaymenttype varchar(20),
);
Insert into Membress Values ('1','Amy','Jhonson','7709123033','109 Harbinsrd','Basic','40','Credit Card');
Create Table Scheduleds(
MemberId INT ,
AirplaneId INT,
Memberpaymentmode Varchar (20),
Memberawrdhours INT,
Usedhours INT,
FOREIGN KEY(MemberId) REFERENCES Membress(MemberId)
);
Insert into Scheduleds Values('1', '1', 'Credit Card', '3', '2');
Insert into Scheduleds Values('1', '2', 'Net Banking', '5', '4');
Insert into Scheduleds Values('2', '2', 'Net Banking', '5', '4'); -- foreign key constrain fails due to parent table doesn't have memberID 2.
Foreign key which is referencing attribute of some other table of primary key. which table has primary key that is called Parent Table and another is Child table
here Membress is Parent Table and Scheduleds is Child Table, In this MemberId referencing Parent Table of Membress table. it means any value that you want to insert into child table that must be present in parent table.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.