Question

Project 2: Course Management App Project description: This android app helps student manage their courses. It enables a student to check the course details (lecturer, term, credits), browse his or her courses, add or remove a course Function modules: 1. Database: build a database for course management, including at least a table for course information (Course number, Course Name, Lecturer, Term, Credit) 2 a table for student infomation (Student number, name, major) a table for student-course (student number, course number) 2. User sign-in A student can sign in the app by offering the student number and password (initial password is the student number, too). Student can change his or her password

Answer 1

Course Management App Project description: This android app helps student manage their courses. It enables a student to check the course details( lecturer, term, credits), browse his or her courses, add or remove a course. Function modules: 1. Database: build a database for course management, including at least a table for course information (Course number, Course Name, Lecturer, Term, Credit) 2 a table for student information (Student number, name, major) 3 a table for student-course (student number, course number)

CREATE THREE TABLE FOR DATABASE BUILDING FOR COURSE MANAGEMENT 1 2 1. CREATE TABLE Course Info ( 4 C No int NOT NULL, 5 C Name varchar (200), 7 8 Lecturer varchar (200), 10 Term int, 11 12 Credit int, 13 14 PRIMARY KEY (C No) 15 16 17 18 Here Couse no is used as primary key 19 SO, 20 CREATE TABLE Student Info ( 21 2. 22 S No int NOT NULL, 23 24 S Name varchar (200) 25 26 27 Major varchar (200) 28 PRIMARY KEY (S No) 29 30 31 32 SO, Here Student no is used as primary key. 33 34 3. CREATE TABLE Student Course 35 36 S No int NOT NULL, 37 38 39 C No int NOT NULL, 40 PRIMARY KEY (S No, C No), 41 42 FOREIGN KEY (S No) REFERENCES Student Info (S No), 43

CREATE THREE TABLE FOR DATABASE BUILDING FOR COURSE MANAGEMENT:

1. CREATE TABLE Course_Info(

C_No int NOT NULL,

C_Name varchar (200),

Lecturer varchar (200),

Term int,

Credit int,

PRIMARY KEY(C_No)

  );

SO, Here Couse no is used as primary key.

2. CREATE TABLE Student_Info(

S_No int NOT NULL,

S_Name varchar (200),

Major varchar (200),

PRIMARY KEY(S_No)

  );

SO, Here Student no is used as primary key.

3. CREATE TABLE Student_Course(

S_No int NOT NULL,

C_No int NOT NULL,

PRIMARY KEY(S_No, C_No),

FOREIGN KEY(S_No) REFERENCES Student_Info(S_No),

FOREIGN KEY(C_No) REFERENCES Course_Info(C_No)

);

In Student_Course table (S_No, C_No) are used as primary key, where S_No and C_No are both foreign key.

Now data can be added to these table by using "INSERT INTO " clause and deletion can be done by "DELETE FROM" clause.