Design and implement relational database for an information system by considering business need and context of the systems.
Assessment Details and Submission Guidelines Trimester T3 2018 Unit Code HS2021 Unit Title HS2021 Database Design and Use Assessment Type Individual Assignment Assessment Title Oriental Bank Database Design Purpose of the assessment (with ULO Mapping) a) Design and implement relational database for an information system by considering business need and context of the systems. b) Retrieve and present information from cross functional areas information using SQL tools and techniques. Weight 15% of the total assessments Total Marks 15 Word limit 1000-1500 words Due Date Week 07 Submission Guidelines Report structure and assignment submission: • Content of your report - Prepare a report which will detail an E-R diagram. - Explain the normalization process of the ER diagram in details. - Write down all the assumptions you have considered while preparing the ER diagram. - Include all the CREATE TABLE statements in the Appendix. • All work must be submitted on Blackboard by the due date along