A patient can undergo a number of tests.Patient information is collected by the hospital and includes SS# (social security number), name, insurance, date of admission, and date checked out.Doctors sometimes consult with a colleague (who is another doctor).All nurses work with doctors (no exception).Nurses have one specialization and belong to a specific department in the hospital.Doctors have nurses that work with/assist them.Doctors have an office and up to three specializations.All hospital staff have a hospital ID, name (first name, middle initial, and last name), and phone number. Hospital staff consists of doctors and nurses.Movie studios hire actors to be in their movies and pay them a great deal of money (salary).Ĭonvert Task 3’s ER diagram to a DB Schema (table names and attributes with primary key).There are various different studios around the world.Movies have titles, the year they came out, a genre, a length, and a rating.Movie stars obviously have names (real and screen in some cases).State any assumptions that you make!Ĭonvert Task 1’s ER diagram to a DB Schema (table names and attributes with primary key). Make sure to include an indication of the cardinality of relationships and indicate any mandatory relationships (total participation). The following were the assignment prompts and my submissions.Ĭreate an ER diagram for the following database scenario. The CS 5012 curriculum included learning to read and build Entity Relationship (ER) diagrams and schemas.
0 Comments
Leave a Reply. |