Computers and Technology, 04.08.2021 05:00 lorry8488
Dean of Admission at DeAnza College has hired you to do the database design for a new registration system. Keeping in the mind the following requirements, design a Database Schema.
1. College has several departments
2. Department offer several courses
3. Courses have sections.
4. College has locations (Room Sem 5 etc.)
5. Students register for a section from a catalog (which is composed of Departments, Courses, Sections, Location.)
6. Students have to pay for the course they take. You may want to think about resident, non resident.
7. Their status is updated based on their registration.
A document to help you remind the symbols for DB Schema is posted in the notes area for Session 1 - called "Introduction to RDBMS. doc".
Entity/Attributes
[PARENT]
User - id(pk), Firstname, Lastname, Address, Email, Telno, ResidentId, Type
[PARENT]
Location - id(pk), Location Name
[PARENT]
Payment - id(pk), PaymentName //Payment - visa/mc/cash - optional
[PARENT]
Resident - id(pk), ResiName, Feeschedule //Resident/Non-Resident
[PARENT]
College id(pk),Name, Address, Telno
[CHILD of College]
Department - id(pk), Name, Locid, Collegeid(fk)
[CHILD of Department]
Course - id(pk), CourseNo, CourseName, Prereq, Deptid(fk)
[CHILD of Course, User(instructor) and Location]
Section - id(pk), SectionNo, Courseid(fk), Locationid(fk), starttime, endtime, startdate, enddate, userid(fk)
[Child of User, Section, Payment]
StudentRegistration - id(pk), StudentID(fk), SectionId(fk)_, FeeStatus, Paymentid(fk)
//student-section
Catalog - view (query - Department, Course, Section, Location)
Relationships
1. College(parent) can have zero or more department(child)
2. Department(parent) has zero or more courses
//Students complete the listing of the relationships
Crow Notation Representation
//Completed by Students
crow notation practice. ppt is just a example and not a complete representation of the schema. You are supposed to create this document and the .ppt file only provides a starting point.
Answers: 1
Computers and Technology, 22.06.2019 22:30
One of your customers wants you to build a personal server that he can use in his home. one of his concerns is making sure he has at least one backup of their data stored on the server in the event that a disk fails. you have decided to back up his data using raid. since this server is for personal use only, the customer wants to keep costs down. therefore, he would like to keep the number of drives to a minimum. which of the following raid systems would best meet the customer's specifications? a. raid 0 b. raid 1 c. raid 5 d. raid 10
Answers: 3
Computers and Technology, 23.06.2019 04:31
Q13 what function does a security certificate perform? a. creates user accounts b. scrambles data c. identifies users d. creates password policies e. provides file access
Answers: 1
Computers and Technology, 24.06.2019 08:00
Arah has entered data about football players from team a and team b in a worksheet. she enters names of players from team a with details about each player in different columns of the worksheet. similarly, she enters details of all the players from team b. which option will her view the data for team a and team b in two separate sections after printing? a. page break view b. freeze pane view c. split screen view d. full screen view e. zoom out view
Answers: 1
Dean of Admission at DeAnza College has hired you to do the database design for a new registration s...
SAT, 23.02.2022 02:00
Mathematics, 23.02.2022 02:00
History, 23.02.2022 02:00
Computers and Technology, 23.02.2022 02:10
Social Studies, 23.02.2022 02:10
History, 23.02.2022 02:10
Computers and Technology, 23.02.2022 02:10