1.create a SQLite database and create tables in it (see below) 2.populate the ta

Question

1.create a SQLite database and create tables in it (see below) 2.populate the tables with data 3.write queries against the data The database should contain the following tables: Students Teachers Courses CourseRegistrations I.e. each course is taught by exactly one teacher (at least in our model, even though this is not true in the real world!), and each course can contain many students. Each student can be enrolled in many courses. You should decide yourself what properties you want to store in the database. For instance, it would make sense to store information about the name of a student, his email address, his real address, postal code, and date of birth. Informations about a course could include the name of the course, plus a description. Obviously we could add other things, but there is no need to make things overly complicated in this assignment. CourseRegistrations should contain information about when the student was enrolled in the course, and what his grade for the course is (if the student has not completed the course, there should be NULL in that column). Finally, you should add data to the tables: enter at least 10 students 4-5 teachers 5-6 courses (name one of them "Inngangur a

Explanation / Answer

Create tables as shown below and this sqlcode where ever needed...for example in java applications with mysql as database CREATE TABLE Students (sid CHAR(9), name VARCHAR(20), login CHAR(8), age INTEGER, gpa REAL); CREATE TABLE Courses (courseid CHAR(6), department CHAR(20)); CREATE TABLE takes (sid CHAR(9), courseid CHAR(6)); CREATE TABLE Students (sid CHAR(9), .... age INTEGER DEFAULT 21, gpa REAL);

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.