CSC3400 | DATABASE SYSTEMS ASSIGN1 CSC850 | DATABASE

CSC3400 | DATABASE SYSTEMS ASSIGN1 CSC850 | DATABASE


IT Assignment help


Question 1.                                      8 marks


Consider the following:

D1     =     fStudent1; Student2; Student3; Student4g

D2     =     f20; 18; 34; 27g

D3     =     fundergraduate; postgraduateg
  • = f(x; y; z) j x 2 D1; y 2 D2; z 2 D3; and y   30g

  • Create a Relation Schema for S given above. Write out both the full and the abbreviated schemas as shown on Slide of the lecture notes in Module 3.

  • Using a table as a physical representation, create a relation for S as defined above. The table should include ALL the possible tuples for S and has column headings that correspond to the attributes of the relation.

  • What is the cardinality of S, the table you have constructed in Ques-tion 1(b)?

  • What is the degree of S?

Question 2.                                                            12 marks


 

Consider the following relational schema:

Student(stdNo, firstName, lastName, eMail)

Course(code, name, credits)

WhenOffered(course, semester, year, examiner)

Staff(staffID, name, birth-date, department)

Transcript(student, course, semes, year, grade)

Related image

This is a schema for a database maintained by a small college to keep track of students, courses, etc. Students have their own unique student ID (which may only contain numbers) and can be contacted via their own unique college email address. There are no two courses having the same code or name. A course is offered at most once per semester (where 1 semester 3), but can be offered in several semesters or in different years. A course offer is examined by a specific member of staff. The examiner can vary over different semesters, and can examine more than one course in a given semester. A staff belongs to one and only one department at the university. A student enrolled in a specific course offer obtains a grade for that course. A student can take a same course multiple times (e.g., fail for a few time and finally pass it), but cannot take the course twice in a single semester of a given year. Students’ and staff’s names are generally NOT unique.

The college typically uses the database to create a list of course names, when they are offered, and the name of the examiner. It also emails reports for each student with their name, the names of courses they have taken and in which semester, the name of their examiner, and the grade they obtained.

In the above relations, we have the following correspondence between attributes (but not limited to): stdNo$student, examiner$ staffID and code$course.

For the following questions, do not use assumptions that are not sup-ported by the description given above. Use the Forum on the course web site to discuss the problem setting if you need clarification.

 
  • Identify all Candidate Keys for each relation.

  • Choose the Primary Key for each relation.

  • Identify all Foreign Keys for each relation. Use the following notation for each Foreign Key:

FK TableName(Attributes) References TableName(Attributes).
  • Consider the following instance for Transcript:

















































































studentcoursesemesyeargrade
     
1CSC240112010NULL
     
1CSC240122010B
     
2CSC3400NULL2011A
     
3CSC340332011F
     
4NULLNULL2011C
     
JeffCSC240612011HD
     
NULLCSC840722011NULL
     

 

Note: Please do not use functional dependencies to answer Questions (a), (b) and (c). You need to identify keys based upon the description given above only.

Indicate which row(s) break the relational integrity rules, and why (there may be more than 1 reason per row).

Punjab Assignment Help


Buy Online Assignment Help services for IT ASSIGNMENT with Punjab Assignment Help at punjabassignmenthelp@gmail.com

Comments

Post a Comment

Popular posts from this blog

Holmes Blackboard | Swinburne blackboard | SCU Blackboard

Usage of virtual Blackboard in Australian popular universities such as Holmes and SCU Key Terms: Holmes blackboard, blackboard holmes, holmes blackboard login, holmes, Swinburne, ilearn, csu login, blackboard, Swinburne online, blackboard uq, Swinburne blackboard, Swinburne library, blackboard uon, myscu, uon blackboard, open colleges login, usyd blackboard, ecu blackboard, ecu student portal, Sydney tafe, learnline, tafe gold coast, scu blackboard, ecu login, blackboard Swinburne, my scu, mais login, vic uni portal, tafe Melbourne, blackboard learn, blackboard ecu, Sydney uni email, my holmesglen, tafe student portal, Swinburne student portal, my uni Sydney, scu library, ecu email, Swinburne student email, education queensland webmail, nsw webmail, Victoria university Sydney, Sydney tafe moodle, ilearn Swinburne, csu student login, uws blackboard, Melbourne uni portal, blackboard scu, holmes institute Melbourne, Melbourne uni lms, Swinburne online, uni melb login Australian Education ...
Read more

How to Write Holmes College Assignments

Image
Holmes College Assignments Holmes College in Australia is renowned educational institute imparting large number of educational courses to the students around the world. Students enrolled in different courses in Holmes are provided with Holmes blackboard login. Holmes blackboard is an online portal which is used to manage all the information pertaining to the enrolled courses from the students such as class notes, announcements, assignments, study resources and other resources related with the course enrolled. Holmes institute Melbourne blackboard is one of the most popular study portals and has become the benchmark in the educational field. Black board holmes is being assigned by the college at the time of initial enrollment by the students. Students are being provided with username and password for holmes institute blackboard login. Each student would get a unique username and password for holmes college blackboard so that they can maintain their account confidential. All the subjects...
Read more

Accounting Assignment Solution

Image
Accounting Assignment Solution Are you an accounting student? Are you laden with tons with assignments, homework that is making your life immensely hectic? So, we Punjab assignment help are here to provide you the benefit of our accounting assignment Solution services, in order to get the services contact us at www.punjbassignmenthelp.com Well, you should know that you are just not the only one. Being an accountancy student is just not easy. It involves the business language of the society. Accounting involves maintenance of finances, investments and laying down all calculations for accounting assignments. A general guideline on Financial Accounting assignment solutions: Try to understand and learn the concepts well from the basic since the beginning. Just as soon as the matter starts in class, give full concentration as to what is being taught in classroom. This not only saves time but also gives you enough time to prepare. Always try to grab the concepts well. In case you are hav...
Read more