Course Name: Course Code: Date & Time of Issue: Database for Small Business BADB2301 Level: Diploma I Section No.: 01 01-11-2021 Deadline (Date & Time): 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 9 Carry out Logical and Physical database design. Assignment Question(s) (Allotted Marks: /15) Drawing 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