Skip to content

README.md

Latest commit

 

History

History
42 lines (31 loc) · 1.37 KB

README.md

File metadata and controls

42 lines (31 loc) · 1.37 KB

Major-Project

Major Project for WD Feb 20 - Mar 20

Description : Creating User Management System

  1. Creating User Database
  2. Collecting User info from front end forms
  3. Showing user info in table
  4. Updating user info from front end forms
  5. Implementing Rest API from NODE and Express to handle user requests to Creating User, Updating User, Reading users, Deleting users

Database Details:

Database name: student_info Tables: student

Field Type Null Key Default Extra id int(10) unsigned NO PRI NULL auto_increment name varchar(50) NO NULL college_name varchar(100) NO NULL contact varchar(15) YES NULL age int(3) unsigned NO NULL

Copy and paste the following commands in SQL query to create the database given above:

create DATABASE student_info; create TABLE student ( id int(10) unsigned auto_increment primary key, name varchar(50) not null, college_name varchar(100) not null, contact varchar(15), age int(3) unsigned not null );

forked