Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

What is meant by 'Wealth Maximization ' ?

Answered: 1 week ago

Question

Conduct an effective performance feedback session. page 360

Answered: 1 week ago