kay21

Hi everyone, Can somebody tell me how to solve the below question please. [QUOTE]Student ([B][U]StudentId[/U][/B], StudentName, Major, Year) Module ([B][U]ModuleId[/U][/B] ,ModuleName, CreditHours, Department) Class ([U][B]ClasssId, ModuleId[/B][/U], InstructorName) GradeSheet ([U][B]StudentId, ClassId, ModuleId[/B][/U], Grade) Prerequisite ([U][B]ModuleId, PrereqId[/B][/U]) Write an optimum relational algebra expression for the following SQL query Select StudentID, ModuleId ,ModuleName, …

Hi everyone, I need help in determining functional dependencies of the given entity sets below. I have also included my answers, please check and advice. Thank you. [CODE][B]OWNER[/B] ([B][U]Owner_SSN[/U][/B], Owner_Name, Owner_Address, {Owner_TelNo}) Owner_SSN -> Owner_Name Owner_Name -> Owner_Address, Owner_TelNo [B]CAR[/B] ([U][B]Car_RegNo[/B][/U], Car_Make, Car_Model, Production_Year, First_Registration, Fuel_Type, Pax_Capacity, First_Purchase_Price, Original_Price) Car_RegNO …

Hi everyone, I have a couple of questions regarding ER to Relational Schema Translation. 1. Do I treat a subclass entity as strong entity 2. Do I need to merge entities where most of the attributes are the same Please advice. Thank you

Hi everyone, Can someone please explain how to determine cardinality ratio for a relationship. For example; In a database for a hospital there is an entity Doctor and Patient. One or more doctors will treat a patient. So, is the cardinality ratio between Doctor and Patient is M:1 (one or …

Hi all, I need some help with defining a recursive relationship in a ER diagram. It is a part of my assignment and the below is quoted in the case study. [QUOTE]Admin staffs are in-charge admitting inpatient to the hospital. Several nurses work in each ward and one of them …

Hi everyone, I need some help with identifying real world entities and their attributes for a hospital scenario. I have listed below the entities and attributes that I could think of. Please comment or give suggestions on how I can improve it. [CODE]EMPLOYEE ([U][B]Employee_SSN[/B][/U], Address_ID, Contact_ID, Employee_Name, Designation, Salary) PATIENT …