Web Reference: Milestone 2 | Assignment - 3 | SQL | NxtWave | CCBP 4.0 Durgam Rajkumar 5.13K subscribers Subscribed Create PROC enrollInCourse @sid INT, @cid INT, @instr int AS BEGIN if (exists (select * from CoursePrerequisiteCourse where cid=@cid)) begin if (exists (select * from StudentTakeCourse where sid=@sid and cid in (select preid from CoursePrerequisiteCourse where cid=@cid))) INSERT INTO StudentTakeCourse (sid,cid,insid) VALUES (@sid,@cid,@instr) else print 'Student didnt take this course pre-requisite' end else INSERT INTO StudentTakeCourse (sid,cid,insid) VALUES (@sid,@cid,@instr) END go CREATE PROC addCreditCard @sid int, @number varchar (15), @cardHolderName varchar (16), @expiryDate datetime, @cvv varchar (3) AS IF (EXISTS (SELECT * FROM Users WHERE id=@sid)) BEGIN INSERT INTO CreditCard VALUES (@number,@cardholderName,@expiryDate,@cvv) insert into StudentAddCreditCard values (@sid,@number) END go CREATE PROC viewPromocode @sid int AS SELECT P.* FROM Promocode P inner join StudentHasPromocode SP on SP.code = P.code where SP.sid=@sid go CREATE PROC enrollInCourseViewContent @id int, @cid int AS BEGIN IF (EXISTS (SELECT * FROM Users WHERE id=@id)) SELECT C.* FROM Course C INNER JOIN StudentTakeCourse STC ON C.id = STC.cid INNER JOIN Student S ON STC.sid = S.id INNER JOIN Users Us ON Us.id = S.id WHERE Us.id = @id and c.id=@cid ELSE print 'not a user' END go CREATE PROC viewAssign @courseId int, @Sid VARCHAR (10) AS BEGIN IF (EXISTS (SELECT * FROM Users WHERE id=@Sid)) SELECT DISTINCT A.* FROM Assignment A INNER JOIN Course C ON A.cid = C.id WHERE C.id = @courseId ELSE print 'not a user' END go CREATE PROC submitAssign @assignType VARCHAR (10), @assignnumber int, @sid INT, @cid INT AS BEGIN IF (EXISTS (SELECT * FROM StudentTakeCourse WHERE cid = @cid AND sid = @sid )) BEGIN IF (EXISTS (SELECT * FROM StudentTakeAssignment WHERE assignmenttype = @assignType AND assignmentNumber = @assignnumber)) print 'Already submitted' ELSE INSERT INTO StudentTakeAssignment values (@sid,@cid,@assignnumber,@assignType,null) END ELSE print 'not enrolled in course' END GO --View the grades of each assignment type. Milestone 3: “75%” Working System, Persistence using SQL database. Your team should demonstrate a working system that implements most of the major system requirements.
YouTube Excerpt: Milestone 2
Information Profile Overview
Milestone 2 Assignment 3 Sql - Latest Information & Updates 2026 Information & Biography
Details: $46M - $66M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 4, 2026
Information Outlook & Future Earnings
Disclaimer: Disclaimer: Information provided here is based on publicly available data, media reports, and online sources. Actual details may vary.