There are many things in you life that you need to keep track of: grocery lists,

Question

There are many things in you life that you need to keep track of: grocery lists, family birthdays and appointments, assignments due for school, and even your hobby or collection. Pick an actual example of something you need to keep track of and design a relational database. Your design must include at least 3 tables following all the rules in chapter 11: records, tables, fields, keys etc. Create a clear diagram of your database showing all of the fields and relationships between the tables and data. Access has a tool for creating this diagram. Include sample data for each table.

Explanation / Answer

So I am going to create database for my study life

For this I am creating three tables

1) for Schedule or Time table

2) Assignments or tasks

3) To track Exams

Schedule table consists of 4 attributes

Subject, Teacher, Time and Day.

Assignment table consists of

Subject,Description, Due Date

Exams Table consists of 3 attributes

Subject, Date of the Exam and Time of the Exam

1) Time Table

CREATE TABLE schedule
(
subject varchar2(15),
teacher varchar2(20),
time date,

day varchar2(8)

);

2) Assignments

CREATE TABLE assignment
(
subject varchar2(15),
description varchar2(30),
due_date date

);

3) Exams:

CREATE TABLE exam
(
subject varchar2(15),

time_of_Exam date,

date_of_Exam date

);

Sample data:

Schedule:

Assignments:

Exam:

If you have any further doubts regarding this please free to comment below.

Thank you

Subject teacher time day C language John paul 10:50-11:40 Wednesday HTML Sara 11:40-12:30 Wednesday

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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