Question: drawing in a paper with relations like this Structured Assignment Course Name: Database for Small Business Course Code: BADB2301 Level: Diploma-1 Date & Time 01-11-2021

drawing in a paper with relations like this
drawing in a paper with relations like this
drawing in a paper with relations like this
Structured Assignment Course Name: Database for Small Business Course Code: BADB2301 Level: Diploma-1 Date & Time 01-11-2021 of Issue: Deadline (Date & Time): Section No.: 01 09-12-2021 Learning Outcomes Covered in the Assignment: Outcome 2 Learn basic design principals in database. Outcome 3 Describe the principles of database design and apply them to practical situations. Outcomes Determine the method for organizing and recording the data. Outcome Carry out Logical and Physical database design. Assignment Question(s) (Allotted Marks: /15) Question 1: A publishing company produces scientific books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more publications. A publication covers essentially one of the specialist subjects and is normally written by a single author. When writing a particular book, each author works with on editor, but may submit another work for publication to be supervised by other editors. To improve their competitiveness, the company tries to employ a variety of authors, more than one author being a specialist in a particular subject. Question 2: General Hospital consists of a number of specialized wards (such as Maternity, Paediatry, Oncology, etc). Each ward hosts a number of patients, who were admitted on the recommendation of their own GP and confirmed by a consultant employed by the Hospital. On admission, the personal details of every patient are recorded. A separate register is to be held to store the information of the tests undertaken and the results of a prescribed treatment. A number of tests may be conducted for each patient. ER Diagram Symbols and Notations Entity Attribute Relationship Weak Entity Multivalued Attribute Weak Relationship CARDINALITY & PARTICIPATION CONSTRAINT + Optional One Mandatory One # Optional Many Mandatory Many Many

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 General Management Questions!