Business Database Development (Databases 2) Repeat Assessment Answer all questions.Questions do not carry equal marks.Bob has been running his hardware store for many years but has recently decided to...

Business Database Development (Databases 2) Repeat Assessment Answer all questions.Questions do not carry equal marks.Bob has been running his hardware store for many years but has recently decided to move from a paper based system to a computerized database system. Like any brick and mortar hardware store, Bob has many suppliers that supply him with different products. Bob also has many customers and of course, Bob has staff which help him to run the store from day to day. Bob has kindly provided us with the following extracts from his paper based system.Customer BookCustomer ID100101102103Supplier BookID001 002003NamePat Murphy Kristan Smith Mary Ryan Tim O DeaContact Number061-228910 054-34789 077-554123 087-145678Balance50010008005600Part NameCarbon Beam Pine Floor, Oak Shelf Circular Saw, Jackhammer, SanderDays Credit30 60 30 90Price11.9920.00, 25.00111,99, 577.99, 55,99 Supplier Name EasyFix Ltd Fancy Wood Ltd.Super ToolsContact PersonTom Jones Jane AndersonJim HendersonPart Number 117ERF 125YUG55792X Bob also holds information about his staff. This information is as follows: Staff Number, Staff Name, Date of Birth, PPSN and IBAN. We have advised Bob that to comply with proper data security measures, the PPSN and IBAN should be stored separately from the rest of the staff data.In addition, Bob would like the following functionality with his new computerized system: To be able to print out a report showing all of his customers and suppliers. Ideally Bob would also like to offer his products for sale online and would ideally like to allow customers and suppliers to register their details online. Bob does not want to allow anyone to have more than 90 days credit.Questions on next page.
Questions.Requirements Gathering [25 Marks]1. Briefly describe some major issues you believe exist with using a paper based system to manage Bob’s hardware store. [5 Marks]2. Make a list of requirements for the store:(i) List General requirements of the system (distinguish between must have functionality and desired features) [5 Marks](ii) List Data Requirements [5 Marks] (iii) List Report Requirements [5 Marks](iv) Make a list of some business rules that we should apply or may already exist [5 Marks]Data Modelling [ 35 Marks]1. 2.Represent the system using Chen Notation diagrams to show the relationships between entities. [10 Marks]Using Crow-Feet Notation produce an ER diagram of the new system. Show mandatory / optional (modality) and cardinality (one to one, one to many, many to many). You must also show the attributes for each entity. [25 Marks]You can use draw.io or a program of your choosing to draw the diagrams.Normalisation [20 Marks]1. Normalize the tables from the customer and supplier book to the third normal form (3NF). You need only show the tables in 3NF, you do not need to show 1NF or 2NF. During this process you may need to create additional tables.SQL [20 Marks]1. Design four entities in SQL. Make sure to implement any relationships using foreign keys. Make sure to include screenshots of each table schema (show how you created each table).You must submit the answers to all questions in 1 word document by July 9th 2021. Do not submit compressed files such as zip files.