CS 425 HW 1.5 (1)

docx

School

Hellen Keller Junior High *

*We aren’t endorsed by this school

Course

425

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

6

Uploaded by DukeBaboonMaster178

Report
CS 425 – DATABASE ORGANIZATION HW- 1.5 TEAM MEMBERS (GROUP – V) CONTRIBUTION Kevan Dedania 20% Ronak Dhingra 20% Manan Hiren Shah 20% Hemanth Vennelakanti 20% Sathwik Vardhan Reddy Pothireddy 20%
Case: Greendale Community College (see spreadsheet data attached on Blackboard ) • A spreadsheet has been created that stores results of students at Greendale Community College. This includes annual promotion code REN (excluded), CON (can continue) or QUA (qualifies), along with information about the courses; their pre-requisites and lecture periods. You are required to design a relational database that can represent the information contained in the spreadsheet as closely and completely as possible.
• Draw an ER (entity-relationship) diagram for the information in the spreadsheet, using the notation employed in this course. If necessary, state any assumptions you had to make when modelling this college data, and explain any modelling decisions taken. Assumptions: Each student in the provided data set possesses a unique identity determined by their name, as well as by other entities delineated in the diagram. The Course Details in the dataset are uniquely identified by their course and convenor, as pre-requisites and periods may be the same, but the combination of course and convenor uniquely distinguishes each Course Detail. Modeling Decisions:
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
• Represent your ERD as a logical design showing relation schemas of this data. Choose 3 or 4 rows from the spreadsheet and show how that data would be stored in your database. Briefly describe any design decisions taken and any limitations of your schema. Now take a example Student Name: Student: Name | Qualify | Promotion Code | Year Eddison N CON 2019 Frost Y QUA 2019 Goya N CON 2019 Hassan N CON 2019 Inggs N CON 2019
Course Detail: Course | Convenor | Pre – Requisites | Periods MAM300 Bauer MAM200 3rd Daily STA321 Mbeki STA220 5th Daily CEM207 Omar CEM100 & PHY131 3rd Daily CSC201 Almeida CSC117 & MAM100 2nd Daily Student Course Name: Name | Course | Mark | Symbol Barnes BOT104 78 1 Chang STA220 56 3 Dawson CEM100 55 3 Eddison CEM207 56 3 • Give any one functional dependency that holds for this information, and state in simple words what your functional dependency tells us about the data. In the example provided, we can identify a functional dependency within the data as follows: Course --> Convenor, Pre Requisites, Periods This functional dependency is valid based on the data presented in the table. In the table, there are instances where the Pre Requisites and Periods are the same, but the Course and Convenor values are distinct and unique. Consequently, we can conclude that Pre Requisites are dependent on the Course, For Example BOT202 Marx BOT104 or ZOO103 5th Daily ZOO203 Lee BOT104 or ZOO103 5th Daily
In the above table "Pre-Requisites" and "Periods" is same but the "Course" is Different. • Is your relation scheme in 1st normal form or not? Give a reason for your answer. • Is your relation scheme in 3rd normal form or not? Give a reason for your answer.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

stats homework 3.pdf
ps1_sp24.pdf
1 - Logistic Regression in Machine Learning - Javatpoint.pdf
Chapter 2 Assignment-1.docx
Ch 1 ICD10 PCS End of Chapter Even Questions.docx
Adan Lab 3 .docx
TSLSYNTAX.docx
Module 1 Guidelines Part 1.docx
1 - Naive Bayes Classifier in Machine Learning - Javatpoint.pdf
Assessing Technology-Based Resources for Differentiation Topic 2.docx
3 - K-Nearest Neighbor(KNN) Algorithm for Machine Learning - Javatpoint.pdf
2 - Decision Tree Algorithm in Machine Learning - Javatpoint.pdf
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
SEE MORE TEXTBOOKS