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

Please answer these questions accurately?!  Please answer these questions accurately?! 1. Present a business problem (fictitious

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

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 Databases Questions!