Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Case Study: Description Consider that you are appointed to develop a Student Time and Attendance Management System table with below requirements. 1. A Timetable will

image text in transcribed
image text in transcribed
image text in transcribed

Case Study: Description Consider that you are appointed to develop a Student Time and Attendance Management System table with below requirements. 1. A Timetable will be built against a Group. A Group stands for a representation of a Batch/Class. Students will be allocated/enrolled into Groups. 2. A Timetable consist of collection of Activities (See below Image where an Activity represents a Session with a. Subject: Subject that will be learning in this Activity Eg English, Business, etc b. Day: Week Day, (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) c. Start Date The Date from which Activity starts d. End Date: The Date from which Activity ends e. Start Time: Starting time of theActivity f. End Time: Ending time of the Activity g. Teacher: The Staff who will be teaching thesubject Group FIA Ca 22 Jan 20mn Group

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Performance Indexing In SQL Server

Authors: Jason Strate, Grant Fritchey

2nd Edition

1484211189, 9781484211182

More Books

Students also viewed these Databases questions

Question

Explain budgetary Control

Answered: 1 week ago

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago

Question

What are the different techniques used in decision making?

Answered: 1 week ago

Question

How do Dimensional Database Models differ from Relational Models?

Answered: 1 week ago

Question

What type of processing do Relational Databases support?

Answered: 1 week ago

Question

Describe several aggregation operators.

Answered: 1 week ago