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
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