Question: Please answer these questions accurately?! 1. Present a business problem (fictitious or real) that requires you to design and implement a database system. Provide at
1. Present a business problem (fictitious or real) that requires you to design and implement a database system. Provide at least one page (standard letter size paper) typed description (use 12 size font) of the business problem. The description should be clear and provide enough details about the business environment, the business processes, and the problem(s) for an individual to understand the complete picture. Your case details should include each of the entity classes and their relationship with others. (30 points) 2. Using Entity-Relationship (E-R) Model, a data modeling technique, create data model for your proposed database system. (50 points) Your E-R model must include the followings a. At least 5 entities b. At least 4 attributes per entity c. At least one 1:1 relationship d. At least one 1:N relationship e. At least one N:M relationship f. At least one (M-M) relationship g. At least one (M-O) relationship h. At least one (O-O) relationship i. At least one Strong-Weak (ID-Dependent/ID-Independent) relationship j. At least one Sub-type/Super-type relationship 3. Label all your diagrams following standard E-R Model rules, including: (20 points) a. Entities b. Attributes c. Relationships
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
