Question: Case study: College Teaching System In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher

Case study: College Teaching System In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A department is known by its name e.g. CSIT, and have a HOD name, Num of students and Floor No. A course is identified by its Code. Course also have name and level of degree. A student must enrol(roll no and Semester as relationship attribute in any one department. A department can have many students. The teacher is assigned class(time and day as attribute) in more than one department. A department has many teachers. A student can study up-to 5 courses by a teacher in given classroom number. Perform the following tasks based on the above case scenario mentioned. a. Find the entity, Attribute and primary key, also draw Entity diagram. b. Draw E-R diagram for each relation, also mention the cardinality

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Case study: College Teaching System In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A...

I just want to ensure I am on the right track. The question I would like an answer to is "Should HT be assigned a going concern classification ? why or why not? Consider whether the amounts in...

Case Study Course Registration System As the head of information systems for Acme College you are tasked with developing a new student registration system. The college would like a new system to...

Nonfunctional Requirements: The student information system (SIS) should be accessible as both a website and a mobile app. The SIS users are students and enrollment staff. The SIS should enforce...

Nonfunctional Requirements The system should be accessible over the internet sentence. Only staff members are the users of the system. The system should ensure that only allowed users are able to use...

IT 315 Student Information System Requirements Definitions Nonfunctional Requirements: The student information system (SIS) should be accessible as both a website and a mobile app. The SIS users are...

must be drawn in uml Analyze the SIS requirements and formalize them as use cases. You should have between four to six use cases. Generate a use case diagram showing the actors associated with each...

Professor suggests this is not a use-case diagram. Not sure as to why, because the textbook seems to demonstrate that it is? Nonfunctional Requirements: The student information system (SIS) should be...

Estimate the number of block accesses required by your solution to Exercise for r1 r2, where r1 and r2 are as defined in Exercise.

Midyear purchase of subsidiarys bonds Sanur Corporation is a 90 percent subsidiary of Pare Corporation. On January 1, 2016, Sanur issued $1,000,000 par, 10 percent 5-year bonds with an unamortized...

Question 8 1 pts A bond issuer is more likely to call the bond if which of the following happens? Tax rates rise. The issuer's credit rating declines. Prevaling interest rates fall. Prevaliling...

Project L requires an initial outlay at t = 0 of $50,000, its expected cash inflows are $13,000 per year for 9 years, and its WACC is 11%. What is the project's NPV? Do not round intermediate...

B How do Anthonys actions differ from those of the three writers mentioned? Does it matter that Tom Joad, the hero of The Grapes of Wrath, never existed?

What kinds of logical fallacies do you regularly see used in the media? What is your reaction when advertisers, political campaigns, or pundits try to persuade you using faulty logic?

A Is it ethical for Anthony to make up a personal account to use as an illustration in his persuasive appeal, even if its based on a true story? Is there a difference between lying for a good cause...