Question

NOTE:

by using Android Studio .Please if you can provide SCREENSHOTSresults and process is the most important parts.

NO ONLY NEED CODE BECAUSE I HAVE IT AND DID IT BUT NEED JUST YOUR RESULTS PHOTOS AND PROCESS THATS COULD HELP ME IN MY PROCESS.

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) 3 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 pass word is the student number, too) Student can change his or her pass word. 3. manage courses student can add a new course to the course table, or remove an existing course from this table student can add or remove his or her selected courses. 4. browse course information student can browse all the courses, no matter they are selected or not. by entering a number like "20191, student can browse all the courses in the first tem in 2019. student can browse all courses he or she has selected, checking for his credits.

Answer 1

sol;

programme for subpart 1

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)

  );, Here Couse no is used as primary key.

programme for 2nd part

2. CREATE TABLE Student_Info(

S_No int NOT NULL,

S_Name varchar (200),

Major varchar (200),

PRIMARY KEY(S_No)

  );

from that above programme here student no is used as primary key

programme for 3rd sub part

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 keytable by using "INSERT INTO " clause and deletion can be done by "DELETE FROM" clause.