For the name attribute of EMPLOYEE, my professor called this type of attribute as "composite", if it were something like color, then he named it as "multi-valued" since it can take many colors as one attribute (ex: black-yellow-red). With this addition, thanks for the clear demonstration.
thank you so mach i am so worried because i take the project of atm and my teacher say me to made erd to atm and this video is very helpful for meeeeeeeeeee
Dear Aishwarya can you make me a video for the following problem please.........??? Case Study I: Relational database Suppose you are hired to design a database for Felege Hiwot Hospital. You conducted interviews with a hospital administrators and staff to identify the key entities for the hospital. You have identified the following entity types: • Care Center-a treatment center within the hospital. Examples of care centers are maternity, emergency care, surgical etc. Each care center has a care center ID (identifier) and a care center name. • Patient-a person who is either admitted to the hospital or is registered as an outpatient. Each patient has a patient ID (identifier), the medical record number (MRN), and a name. • Physician-a member of the hospital medical staff who may admit patients to the hospital and who may administer medical treatments. Each physician has a physician ID (identifier) and name. • Bed-a hospital bed that may be assigned to a patient who is admitted to the hospital. Each bed has a bed number (identifier), a room number, and a care center ID. • Item-any medical or surgical item that may be used in treating a patient. Each item has an item number (identifier), description, and unit cost • Employee-any person employed as part of the hospital staff. Each employee has an employee number (identifier) and name. • Diagnosis-a patient’s medical condition diagnosed by a physician. Each diagnosis has a diagnosis ID and diagnosis name. • Treatment-any test or procedure ordered by and/or performed by a physician for a patient. Each treatment has a treatment ID and treatment name. • Order-any order issued by a physician for treatment and/or services such as diagnostic tests (radiology, laboratory) and therapeutic procedures (physical therapy, Die orders) or drugs (prescriptions). Each order has an order ID, order date and order time You further recorded the following relationships. • Each hospital employee is assigned to work in one or more care centers. Each care center has at least one employee and may have any number of employees. The hospital records the number of hours per week that a given employee works in a particular care center • Each care center has exactly one employee who is designated nurse-in-charge for that care center. • A given patient may or may not be assigned to a bed (since some patients are outpatients). Occupancy rates are seldom at 100 percent, so a bed may or may not be assigned to a patient. • A patient may be referred to the hospital by exactly one physician. A physician may refer any number of patients or may not refer any patients. • A patient must be admitted to the hospital by exactly one physician. A physician may admit any number of patients or may not admit any patients. • Prior to a patient being seen by a physician, a nurse typically obtains and records relevant information about the patient. This includes the patient’s weight, blood pressure, pulse, and temperature. The nurse who assesses the vital signs also records the date and time. Finally, the reasons for the visit and any symptoms the patient describes are recorded. • Physicians diagnose any number of conditions affecting a patient, and a diagnosis may apply to many patients. The hospital records the following information: date and time of diagnosis, diagnosis code, and description. • Physicians may order and perform any number of services/treatments for a patient or may not perform any treatment. A treatment or service may be performed on any number of patients, and a patient may have treatments performed or ordered by any number of physicians. For each treatment or service rendered, the hospital records the following information: physician ordering the treatment, treatment date, treatment time, and results. • A patient may also consume any number of items. A given item may be consumed by one or more patients, or may not be consumed. For each item consumed by a patient, the hospital records the following: date, time, quantity, and total cost (which can be computed by multiplying quantity time’s unit cost). Draw an ER diagram for Felege Hiowt Hospital based on the given requirements. Please incorporate all the necessary constraints (cardinality ratio and participation constraints and min-max) in your diagram.
Joint Accounts If you have a joint account that belongs to both YOU and say your DAD, then account is one, but for that account customers are 2 (You and your dad) Or You can take this example A bank account of an organization. This organization may have multiple owners. So by creating an account in the name of the organization, this account is controlled by all the owners of that organization.
Thank you very much, you should
continue your great tutorial series!!!!
Thank you so much.. I m considering to start the tutorials again. Happy to help.
For the name attribute of EMPLOYEE, my professor called this type of attribute as "composite", if it were something like color, then he named it as "multi-valued" since it can take many colors as one attribute (ex: black-yellow-red). With this addition, thanks for the clear demonstration.
loved it ! found this one video among hundreds of those that didnt caught my brain..! thanks!
OMG my teacher didnt explain this good in 4 (2 hours ) classes. Thankyou
Thankful to u its good, if some one put bad comment don't feel bad they don't know the value of explanation
Thank you
@@thetutorialpgno1 Yep, this explanation is perfect and simple, better than University explanation
Well explained But where you said that employ has multi value of its name with lst, Mid,full name tht is a composite attribute not multivalue.
What are you doing now.
Thank you so much best video I’ve seen yet you made it so simple
Welcome. I am glad that u liked the video😊
Today I fell how the genius student /professor think on the problem..awsm ... explanation... keep it continue ....
Thank you so much
@@thetutorialpgno1 your wlcm
Thank you ma'am really after so many videos this video will be more easy to me 💫
Ur voice🤩... U sound so young but still so good at teaching🙏
Such an easy explanation.... totally loved it❤
Thanx ..helped to a good extent.
really helpful!!!Thank you
vedio still useful after 7 years ..........
cardinality ratio and proportion constant , acche se smjha for that thanks.
Excellent presentation 👌🏻
Thanks you ,you explained me simple one
thank you so mach i am so worried because i take the project of atm and my teacher say me to made erd to atm and this video is very helpful for meeeeeeeeeee
I am glad that it helped u
Dear Aishwarya can you make me a video for the following problem please.........???
Case Study I: Relational database
Suppose you are hired to design a database for Felege Hiwot Hospital. You conducted interviews with a hospital administrators and staff to identify the key entities for the hospital. You have identified the following entity types:
• Care Center-a treatment center within the hospital. Examples of care centers are maternity, emergency care, surgical etc. Each care center has a care center ID (identifier) and a care center name.
• Patient-a person who is either admitted to the hospital or is registered as an outpatient. Each patient has a patient ID (identifier), the medical record number (MRN), and a name.
• Physician-a member of the hospital medical staff who may admit patients to the hospital and who may administer medical treatments. Each physician has a physician ID (identifier) and name.
• Bed-a hospital bed that may be assigned to a patient who is admitted to the hospital. Each bed has a bed number (identifier), a room number, and a care center ID.
• Item-any medical or surgical item that may be used in treating a patient. Each item has an item number (identifier), description, and unit cost
• Employee-any person employed as part of the hospital staff. Each employee has an employee number (identifier) and name.
• Diagnosis-a patient’s medical condition diagnosed by a physician. Each diagnosis has a diagnosis ID and diagnosis name.
• Treatment-any test or procedure ordered by and/or performed by a physician for a patient. Each treatment has a treatment ID and treatment name.
• Order-any order issued by a physician for treatment and/or services such as diagnostic tests (radiology, laboratory) and therapeutic procedures (physical therapy, Die orders) or drugs (prescriptions). Each order has an order ID, order date and order time
You further recorded the following relationships.
• Each hospital employee is assigned to work in one or more care centers. Each care center has at least one employee and may have any number of employees. The hospital records the number of hours per week that a given employee works in a particular care center
• Each care center has exactly one employee who is designated nurse-in-charge for that care center.
• A given patient may or may not be assigned to a bed (since some patients are outpatients). Occupancy rates are seldom at 100 percent, so a bed may or may not be assigned to a patient.
• A patient may be referred to the hospital by exactly one physician. A physician may refer any number of patients or may not refer any patients.
• A patient must be admitted to the hospital by exactly one physician. A physician may admit any number of patients or may not admit any patients.
• Prior to a patient being seen by a physician, a nurse typically obtains and records relevant information about the patient. This includes the patient’s weight, blood pressure, pulse, and temperature. The nurse who assesses the vital signs also records the date and time. Finally, the reasons for the visit and any symptoms the patient describes are recorded.
• Physicians diagnose any number of conditions affecting a patient, and a diagnosis may apply to many patients. The hospital records the following information: date and time of diagnosis, diagnosis code, and description.
• Physicians may order and perform any number of services/treatments for a patient or may not perform any treatment. A treatment or service may be performed on any number of patients, and a patient may have treatments performed or ordered by any number of physicians. For each treatment or service rendered, the hospital records the following information: physician ordering the treatment, treatment date, treatment time, and results.
• A patient may also consume any number of items. A given item may be consumed by one or more patients, or may not be consumed. For each item consumed by a patient, the hospital records the following: date, time, quantity, and total cost (which can be computed by multiplying quantity time’s unit cost).
Draw an ER diagram for Felege Hiowt Hospital based on the given requirements. Please incorporate all the necessary constraints (cardinality ratio and participation constraints and min-max) in your diagram.
haan bhai , problem solve hui k nai ??? ;)
hi aish, great tutorial. Can I get the full series of it? Pls reply as you see.
thank you the diagram was explained very well.
Thank you mam it's was very helpful.. can you make more DBMS topics
How will I have the attributes? Will it be given in the question?
Perfectly understandable
thanks a lot ma'am very helpful
its some how good you have to keep up especially the quality video
Thankyou Sis
Thanks akka ♥️
Nice tutorial .
thanks a lott ayshuu... its very use full... ❣
7:14 ...can a account have more than one customer??(ignore joint account)
Awesome video
Conceptual lecture thanks di
a particular account can belong to only one user..and the name is a composite attribute not a multivalued one
Could you please make another videos on ER diagrams .
Beautiful explained 😊
Thanks
thank you so much for nice discribing .
Well explained! Good job girl.
Aish and Salman 🎉
thank you ma'am for this video
Nice
👍
I need ER diagram on database system
wow! great!!!
Super mam,ur explanation semmmmaaaa mam👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌👌
thank you very much
dii
Voice is very Nice!
You done very well miss
Adipolli🔥
Maza aaya 👍🏻
Thanks.will u share how to reduce the ER diagram to relational schema plz
very nice explanation. loved it. But I have same pencil that of urs. :D
Awesome
😘😘
thanks
where its 1 to N or M to N there can i use 1 to M and M to M?
Thank you soo much
Yo clearly explain everything maam
Don't we need to use arrow in anywhere?
good one :)
+k shravya thank u
Thanks ma'am
Where is cardinality video ?
How we can give a name to relation i.e u gave has in diagram ?
I need the clear picture of the diagram
Good video
amazing
hii di can you help me in making er diagram for a case study of liabrary
Thankful guy
Nice explanation
Thank you 😊
@@thetutorialpgno1 thanks mam 4 reply
Hello maam,need an help in making an ER for a project , please help me maam
Super
Thank u
didi thoda jyda bda nai hogya er diagram
Hlo Aish....kesi ho...mai Rahul
Please provide Gas booking system er diagram
Hi
how an account can have many customers??? because accounts will be different for every customers... Please explain.!!
Joint Accounts
If you have a joint account that belongs to both YOU and say your DAD, then account is one, but for that account customers are 2 (You and your dad)
Or
You can take this example
A bank account of an organization.
This organization may have multiple owners.
So by creating an account in the name of the organization, this account is controlled by all the owners of that organization.
Movie database
cardinality is very unclear
Very poor video qualify
very bad not clear video
thanks
thanks
thanks