Question: Part A: Develop a sql script to perform the following tasks 1. Using a SQL Script create a database named [YourStudentNo]_Assn3_MVC 2. Create following two

Part A: Develop a sql script to perform the following tasks 1. Using a SQL Script create a database named [YourStudentNo]_Assn3_MVC 2. Create following two tables Table Name : [StudentNo]_Students Note: replace [StudentNo] with your student number StudentID int FirstName varchar(25) LastName varchar(30) Program Varchar(10) Table Name : [StudentNo]_Courses Note: replace [StudentNo] with your student number CourseCode int StudentID int CourseTitle varchar(12) Description Text Credits Decimal(10,2) Note : Student ID is the primary key in Students Table and It is the foreign key in the courses table Enter relevant data items to the tables using database script Create a single sql script to perform all the above tasks Name the sql script file as [Yourstudent_no]_18W_proj3.sql 3. Now run the script on MySQL and see whether the database is created with data values Part B: Note: refer to the following link and/or the lecture slides /other resources before attempting Part B https://www.killersites.com/articles/MVC.htm Create a MVC Based web application to retrieve the data from the server (localhost) and display the result 1. First screen of your application should display the student numbers from students table as follows (This is sample screen only) 2. When you select the student number (e.g. 677677) from the left navigation pane, the courses that particular student is following should display in the right pane is shown below. (This is sample screen only) 3. a. Create a button(s) to add a student to the students table and courses to the courses table b. Create a button(s) to delete students and courses. Extra: c. Create a button to update courses in courses table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!