Question: How might we specify the following SQL in MongoDB ? CREATE TABLE course ( code CHAR ( 3 ) PRIMARY KEY, name VARCHAR ( 3
How might we specify the following SQL in MongoDB
CREATE TABLE course
code CHAR PRIMARY KEY,
name VARCHAR NOT NULL,
credits TINYINT NOT NULL
;
INSERT INTO course codenamecredits
VALUES
WSD 'Web Systems Development',
DDM 'Database Design & Management',
NSF 'Network Security & Forensics', ;
CREATE TABLE Module
code CHAR PRIMARY KEY,
name VARCHAR NOT NULL,
cost DECIMAL NOT NULL,
credits TINYINT NOT NULL,
coursecode CHAR NOT NULL,
CONSTRAINT fkcoursecode
FOREIGN KEY coursecode
REFERENCES course code
ON UPDATE CASCADE
ON DELETE RESTRICT
;
INSERT INTO module codenamecostcreditscoursecode
VALUES
A 'ASP.NET', WSD
APHPWSD
A 'JavaFX', WSD
B 'Oracle', DDM
BSQLSDDM
C 'Law', NSF
C 'Forensics', NSF
C 'Networks', NSF;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
