Star Schema University Attendance Databse

In: Computers and Technology

Submitted By sinovuvu
Words 328
Pages 2
You must create a Star Schema University Attendance database for the following situation:
The database must record attendance of students in classes, the time of the lecture, the lecturer who taught the class, the room that was used and the subject for that lecture. For each subject you must record the total number of classes timetabled for the semester – this will be used to calculate Student attendance percentage and Lecturer attendance percentage. An attendance fact must always contain a valid lecturer-id; we assume if one lecturer is absent then another will take his/her place.
You may assume maximum room usage is 11 X 5 = 55 periods a week.
You can work out the primary key of the fact table from the above specification.
The following criteria must be met:
1) This is an individual assignment.
2) You must write SQL statements to enter the data; Try not to repeatedly enter the same thing for one class.
3) You will need reports to provide:
a) % usage of rooms
b) % attendance of students
c) % attendance of lecturers
d) At least 2 other reports of interest
4) You must enter at least 30 fact records (this is a factless fact table); in all 10 students, 5 different lecturers, 3 different rooms, 2 subjects and 10 date/time slots as your initial prototype system.
5) (Optional). You must load your fact table from an operational database in batch mode –
e.g. a file with values St No Lect –Id Room Subj Date Time
1 1 1 2 20110718 1130
2 1 1 2 20110718 1130
6 1 1 2 20110718 1130

Or (1, 2, 6) 1 1 2 110718 1130 - much shorter etc. showing all students attending a given class
You will be evaluated to check system meets all practical requirements (works properly):
 Check star schema structure (7)
 Check fact table for suitable data (6)
 Check entry of data (14)
 Check reports (13)
 Demonstration (10)
 (Optional ) Batch entry of…...

Similar Documents

Attendance

...Attendance and Participation Quiz Question 1 What is the attendance policy for University of Phoenix online courses? One message to any class forum on 2 separate days during the online week Question 2 Which of the following students has met the attendance requirement for an online course? Max posted one message on 2 separate days during the online week. Question 3 What is the participation requirement for University of Phoenix online courses? Two substantive discussion messages 4 days each online week in the Main forum Question 4 Which of the following students has met the participation requirement for an online course? Suli posted two substantive discussion messages on 4 separate days during Week One. Question 5 How many total participation posts for University of Phoenix online courses are needed to meet the participation requirement in an online week? 8 Question 6 What is a substantive discussion message? Both (a) and (b). Question 7 A classmate posts a message by saying only “I agree” in response to a discussion post made by the facilitator about leadership. Is this discussion message substantive or not substantive? This discussion message is not substantive, because it does not further the discussion. Question 8 A classmate begins the following discussion message by saying, “I had a similar experience in my work as a computer consultant. When I encounter a computer problem I am unable to troubleshoot, I consult websites to determine the solution...

Words: 384 - Pages: 2

Time and Attendance

...witnessing a new kind of revolution—the Information Revolution—ushered in by technology. This revolution is far more sweeping than any other revolution in history in its reach and influence, bringing fundamental changes in all aspects of our life. Information technology is the use of computers and software to manage information. As computers grew in speed and capability, a number of general-purpose database systems emerged. In the present context, I have great pleasure in presenting “Factory Time Attendance Management System (FTAMS)” program. This program is used by factories of all sizes. The FTAMS works with RFID time attendance devices to manage working hours of employees recorded in the devices in order to pay their wages. FTAMS could protect a factory from payroll fraud and provide both employer and employees with confidence in the accuracy of their wage payments. The present system is necessarily providing a convenient, simple, and comprehensive program on managing the time and attendance system for the benefits of employees and the factory. I wanted to take this opportunity to welcome you to your education. Writing this book has been a lot of fun for me and I sincerely hope that you get a lot out of it. I have tried to be balanced in presenting both the advantages and disadvantages of some of the new ideas. I encourage you to adopt a similar open and critical stance when reading this book. You are welcome to e-mail me at so.sereyboth@gmail.com with your......

Words: 10985 - Pages: 44

Star Schem & Snowflake Schema

...we will go through different Schema that can be used during Dimensional Modelling to create a Data Warehouse. Before we start with today's topic , For my viewers those who are new to this field i would like to revisit some of the key points of my previous blogs: 1) Business Intelligence is mainly divided into three parts as per my understanding a) Data Warehouse design and Implementation (ETL process) b) Data Analysis (Using OLAP cubes) c) Reporting and Dashboard Creation For further details revisit my First blog 2) Important Components involved in Dimensional Modelling or Data Warehouse Designing a) Fact Tables (Additive Facts, Semi-Additive Facts, Non- Additive Facts) b) Dimension Table c) Grain For further details revisit my Second blog After a thorough revision of previous concepts lets start our today's discussion about different Schema involved in Dimensional Modelling or Data Warehouse Designing. First of all i would like to explain the meaning of the topic i.e Snow Covered Wagon Hitched to a Star = SnowFlake Schema and Star Schema are two types of Schema that are used while designing a Data Warehouse, Hence they can be explained as follows: Star Schema: A Star Schema is one of the simplest and easiest schema to understand. A schema which consists of Dimension tables only attached to Fact tables. A Star Schema get its name from its......

Words: 557 - Pages: 3

Database Star Schema

...Information Systems 3 (database 3) Star Schema Due 19/06/2014 You must create a Star Schema University Attendance database for the following situation: The database must record attendance of students in classes, the time of the lecture, the lecturer who taught the class, the room that was used and the subject for that lecture. For each subject you must record the total number of classes timetabled for the semester – this will be used to calculate Student attendance percentage and Lecturer attendance percentage. An attendance fact must always contain a valid lecturer-id; we assume if one lecturer is absent then another will take his/her place. You may assume maximum room usage is 11 X 5 = 55 periods a week. You can work out the primary key of the fact table from the above specification. The following criteria must be met: 1) This is an individual assignment. 2) You must write SQL statements to enter the data; Try not to repeatedly enter the same thing for one class. 3) You will need reports to provide: a) % usage of rooms b) % attendance of students c) % attendance of lecturers d) At least 2 other reports of interest 4) You must enter at least 30 fact records (this is a factless fact table); in all 10 students, 5 different lecturers, 3 different rooms, 2 subjects and 10 date/time slots as your initial prototype system. 5) (Optional). You must load your fact table from an operational database in batch mode – e.g. a file with values St No Lect –Id Room Subj Date......

Words: 401 - Pages: 2

Star Schema

...Information Systems 3 You must create a Star Schema University Attendance database for the following situation: The database must record attendance of students in classes, the time of the lecture, the lecturer who taught the class, the room that was used and the subject for that lecture. For each subject you must record the total number of classes timetabled for the semester – this will be used to calculate Student attendance percentage and Lecturer attendance percentage. An attendance fact must always contain a valid lecturer-id; we assume if one lecturer is absent then another will take his/her place. You may assume maximum room usage is 11 X 5 = 55 periods a week. You can work out the primary key of the fact table from the above specification. The following criteria must be met: 1) This is an individual assignment. 2) You must write SQL statements to enter the data; Try not to repeatedly enter the same thing for one class. 3) You will need reports to provide: a) % usage of rooms b) % attendance of students c) % attendance of lecturers d) At least 2 other reports of interest 4) You must enter at least 30 fact records (this is a factless fact table); in all 10 students, 5 different lecturers, 3 different rooms, 2 subjects and 10 date/time slots as your initial prototype system. 5) (Optional). You must load your fact table from an operational database in batch mode – e.g. a file with values St No Lect –Id Room Subj Date Time 1 1 1 2 20110718 1130 2 1 1 2 20110718 1130 6 1...

Words: 292 - Pages: 2

Attendance

...Attendance and Participation Quiz Question 1 What is the attendance policy for University of Phoenix online courses? One message in the online classroom on 2 separate days during the online week Question 2 Which of the following students has met the attendance requirement for an online course? Max posted one message on 2 separate days during the online week. Question 3 What is a substantive discussion message? Both (a) and (b). Question 4 A classmate posts a message by saying only “I agree” in response to a discussion post made by the facilitator about leadership. Is this discussion message substantive or not substantive? This discussion message is not substantive, because it does not further the discussion. Question 5 A classmate begins the following discussion message by saying, “I had a similar experience in my work as a computer consultant. When I encounter a computer problem I am unable to troubleshoot, I consult websites to determine the solution. Our textbook also lists websites at the end of Chapter 10 that are good resources for troubleshooting.” Is this discussion message substantive or not substantive? This discussion message is substantive, because it furthers the discussion by adding new ideas and a personal perspective. Question 6 This week's class discussion is about comparing points of view on political candidates in newspaper articles to determine bias in the media. A classmate posts a message stating, “Electric cars are better for the......

Words: 305 - Pages: 2

Star Schema

...Information Systems 3 (database 3) Star Schema Draft 1 You must create a Star Schema University Attendance database for the following situation: The database must record attendance of students in classes, the time of the lecture, the lecturer who taught the class, the room that was used and the subject for that lecture. For each subject you must record the total number of classes timetabled for the semester – this will be used to calculate Student attendance percentage and Lecturer attendance percentage. An attendance fact must always contain a valid lecturer-id; we assume if one lecturer is absent then another will take his/her place. You may assume maximum room usage is 11 X 5 = 55 periods a week. You can work out the primary key of the fact table from the above specification. The following criteria must be met: 1) This is an individual assignment. 2) You must write SQL statements to enter the data; Try not to repeatedly enter the same thing for one class. 3) You will need reports to provide: a) % usage of rooms b) % attendance of students c) % attendance of lecturers d) At least 2 other reports of interest 4) You must enter at least 30 fact records (this is a factless fact table); in all 10 students, 5 different lecturers, 3 different rooms, 2 subjects and 10 date/time slots as your initial prototype system. 5) (Optional). You must load your fact table from an operational database in batch mode – e.g. a file with values St No Lect –Id Room Subj......

Words: 377 - Pages: 2

Attendance

...Lancaster University Management School Working Paper 2005/004 New issues in attendance demand: The case of the English football league Simmons, Rob and Forrest, David The Department of Economics Lancaster University Management School Lancaster LA1 4YX UK ©Simmons Rob and Forrest David All rights reserved. Short sections of text, not to exceed two paragraphs, may be quoted without explicit permission, provided that full acknowledgement is given. The LUMS Working Papers series can be accessed at http://www.lums.co.uk/publications/ LUMS home page: http://www.lums.lancs.ac.uk/ NEW ISSUES IN ATTENDANCE DEMAND: THE CASE OF THE ENGLISH FOOTBALL LEAGUE David Forrest* University of Salford Rob Simmons** Lancaster University November 2004 *School of Accounting, Economics and Management Science, University of Salford, Salford M5 4WT, e-mail: d.k.forrest@salford.ac.uk. Phone: 0044 (0)161 295 3674, Fax: 0044 (0)161 295 2130. **(Corresponding author) Department of Economics, The Management School, Lancaster University, Lancaster LA1 4YX, e-mail: r.simmons@lancaster.ac.uk. Phone 0044 (0)1524 594234, Fax 0044 (0)1524 594244. Acknowledgement We are grateful to two referees, Tunde Buraimo and participants at the Applied Econometrics Association, Football’s Econometrics Conference, in Patras, Greece, for helpful comments on an earlier draft. 1 ABSTRACT This paper uses an attendance demand model with panel data on over 4,000 games to examine economic problems of fixture congestion in...

Words: 9257 - Pages: 38

Databses

...NWUUser North-West University  [Company address] [Document title] NWUUser North-West University  [Company address] [Document title] CONTENT PAGE Database Initial Study 1. Analysis of the company situation 2. Define problems and constraints Problems Constraints * Each value in a column must not be null * Values in specified columns must be unique for each row in a table e.g. pens can be distinguished by their respective I.DS. * Primary Key- These are unique and are used to identify individual records e.g. patient_id will return records about a specific patient only. * Foreign Key – Values in specified columns must reference an existing record in another table (via its primary key) e.g. treatment_num from the table treatments can appear as a foreign key value in the pet treatment table 3. Define the system Objectives * Develop a system that cost effective * Understand the way the current system works, and enhance its future performance * Ensure the delivery of a high quality system * External entities must be able to comprehend and manoeuvre the system * Incorporate changes easily and quickly * Share data amongst users * Improve accuracy & consistency * Reduce data redundancy as much as possible * Provide data security from unauthorised access * To always ensure the validity of data 4. Define Scope & Boundaries Scope * The database should be able to generate......

Words: 273 - Pages: 2

Star Schema University Attendance Database

...You must create a Star Schema University Attendance database for the following situation: The database must record attendance of students in classes, the time of the lecture, the lecturer who taught the class, the room that was used and the subject for that lecture. For each subject you must record the total number of classes timetabled for the semester – this will be used to calculate Student attendance percentage and Lecturer attendance percentage. An attendance fact must always contain a valid lecturer-id; we assume if one lecturer is absent then another will take his/her place. You may assume maximum room usage is 11 X 5 = 55 periods a week. You can work out the primary key of the fact table from the above specification. The following criteria must be met: 1) This is an individual assignment. 2) You must write SQL statements to enter the data; Try not to repeatedly enter the same thing for one class. 3) You will need reports to provide: a) % usage of rooms b) % attendance of students c) % attendance of lecturers d) At least 2 other reports of interest 4) You must enter at least 30 fact records (this is a factless fact table); in all 10 students, 5 different lecturers, 3 different rooms, 2 subjects and 10 date/time slots as your initial prototype system. 5) (Optional). You must load your fact table from an operational database in batch mode – e.g. a file with values St No Lect –Id Room Subj Date Time 1 1 1 2 20110718 1130 2 1 1 2 20110718 1130 6 1...

Words: 328 - Pages: 2

Star Schema

...Information Systems 3:ISY300B/ISY313B ______________________________________________________________________ 2016 Informatics & Design National Diploma Information Technology INFORMATION SYSTEMS 3 (MODULE B) (ISY300B) SUBJECT GUIDE 2016 NQF LEVEL: 7 ____________________________________________________________________________ 2015 Cape Peninsula University of Technology, Informatics & Design 1 Information Systems 3b (ISY300B, ISY313B) PREREQUISISTE SUBJECTS: Information Systems 2 or equivalent ____________________________________________________________________________  2015 Cape Peninsula University of Technology, Informatics & Design Page 2 of 18 Information Systems 3b (ISY300B, ISY313B) Table of contents Organisational component 1. Introduction / Word of welcome .......................................................................... 1 2. General .................................................................................................................. 2 3. Study materials and purchases ........................................................................... 3 4. Module credits ...................................................................................................... 4 5. Assessment .......................................................................................................... 5 5.1 5.2 6. Assessment policy and regulations ............................................................. 5.1 Assessment opportunities:......

Words: 3807 - Pages: 16

All Stars

...around 750 000 participating members. The All Star Games is an annual culmination of these site level activities. The best of the best in the respective activities and disciplines is selected to compete against each other at one major event. The event platform caters for representation from across the full spectrum of loveLife sites/regions/provinces. Some of the key features of the loveLife All Star Games include: ▪ Presence of over 2200 participants competitively competing for top honours in respective sports and recreational codes. ▪ Spectator attendance is prudently estimated at + - 3000 individuals all enjoying the games spectacle. ▪ All Star Games is a massive community mobilisation catalyst, creating activism at multiple levels. ▪ The All Star Games is a life changing experience for all delegates who participate, the event is more then a sporting event it is a holistic life experience incorporating elements of: • Celebrity performances • Guest motivational Speakers • Career guidance • Physical assessment • Media coverage from various platforms ▪ The All Star Games is a powerful platform for the critical face to face interaction needed to bring about much needed change around various social ills. Details of Event Dates and Times Thursday 6th December 2007 till Sunday 9th December 2007 Location The University of the Free State, participants to be......

Words: 1231 - Pages: 5

Developing Schemas

...When hearing the word schema people would not be able to explain what it means, and not realize that they use it in their everyday life. However it’s simple, schema is a concept that helps organize and interpret information. Schemas can be useful, because they allow us to take shortcuts in understanding a large amount of information. However, the concept can also cause us to reject relevant information in favor of information that confirms our pre-existing beliefs and ideas. Schemas can contribute to stereotypes and make it difficult to recall new information. So in order to understand schemas and the effects it has on a person’s life I formed a small case study. To start with, when starting the project, I first asked 10 participants who are in my family as well as my friends to help me in a project for psychology. Secondly I told the participants “I’m going to recite 12 words to you and show you those words at the same time.” The words were: Rest, Tired, Awake, Dream, Snore, Bed, Eat, Slumber, Sound, Comfort, Wake, and Night. After reciting the words I asked each participants what their name, age, and occupation was and when I went back to the list of words it seemed as all the words I recited to them didn’t matter, since they were more focused on the series of questions I asked 30 seconds after reciting the words. Next, I had asked the participants to write all the words they could remember within two minutes, but almost all ten participants had given up within a minute,......

Words: 889 - Pages: 4

Good Attendance at University Is an Out-Dated Ideal”: the Views of Staff and Students.

...“Good attendance at university is an out-dated ideal”: the views of staff and students. By Dr Ann Walker This paper reports on the second stage of an attendance monitoring project in which academic staff and students identified as good, average and poor attendees contributed to focus group discussions. In total ten focus groups were held, with thematic analysis identifying the key themes of motivators for attending, motivators against attending, assessment considerations, attendance and marks, reward versus punishment, student autonomy, purpose of attendance monitoring, and problems with monitoring attendance. The findings are discussed in relation to Social Exchange Theory and Social Learning Theory. Introduction This is the second report on a first year attendance monitoring project which is being carried out at the university where I work. In our first paper, we reported that we had found a significant correlation between absence and marks with students with poorer attendance records receiving lower end-of-semester marks. We also found that the poorer attenders were more likely to withdraw, either temporary or permanently, from the course. This finding is in keeping with those of similar studies going back over 50 years (for summary see Richie & Hargrove 2004/05). Two psychological theories, Social Exchange Theory and Social Learning Theory, have been put forward as explanations for the relationship between absence and marks. Social Exchange Theory......

Words: 6782 - Pages: 28

Attendance

...Arun Kumar Mishra and Debidutt Acharya, “WIRELESS FINGERPRINT BASED STUDENT ATTENDANCE SYSTEM” , 2010. Biometrics is the very study of identifying a person by his/her physical traits that are inherent and unique to only the person concerned. Biometric measurement and assessment include fingerprint verification, iris recognition, palm geometry, face recognition etc. The above mentioned techniques work with different levels of functionality and accuracy. Accuracy and reliability are the two most important parameters when it comes to biometric applications. Fingerprint verification is one of the oldest known biometric techniques known but still is the most widely used because of its simplicity and good levels of accuracy. It’s a well known fact that every human being is born with a different pattern on the fingers and this feature is exploited to identify and differentiate between two different persons. The application in an educational institute is worth noting because of the benefits it brings along with it. The fingerprint recognition and verification technique can easily replace an attendance sheet and save time wasted on calling out roll numbers in the class. A fingerprint detecting device needs to be placed in each classroom and students would be made to swipe their finger over the sensor so as to mark their presence in the class. The database would contain all the fingerprints beforehand. So, the moment a finger would be swiped, a check......

Words: 978 - Pages: 4