Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 1 the number of tables is ? Q 2 which of the folloeing sql statements is used to define a table in the exam
Q the number of tables is
Q which of the folloeing sql statements is used to define a table in the exam db database assume thst thr defined tables do not cause any referential integrity constraints violations enter abcd
Acreate table owns
Purchase date DATE;
BCREATE TABLE Owns
Id CHAT
Purchasedate date
Primary keyidvehichle id
Foreign keyid refrences compsny id
Foreign key vehicle id refrences vehiclesvehiclr id;
Ccreate table oens
id char
Vehicle id char
Purchase date date
Primary key idvehicle id;
Q which of thr following statements is teue abiut the constraints invthe er mapping processing?
A All constraints in the er diagrsm csn be captured
Bthe participation constraint between compant and owns cannot br capturef
c The total soecialization constraint for vehicledcan not br captured
Dthe disjoint cobstraint for thr vehiclees also can be capturef
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started