Suppose you are asked to create an information system for a large marketing firm that requires a database. Answer the following questions.

a) List the major three stages of the database design phase in the database system development life cycle (DBDLC) and describe each of them briefly.

b) Create a complete conceptual data model using the Entity Relationship Diagram (ERD) for the data requirements of the marketing firm stated as:

The marketing firm has a number of employees. It also has several projects. Each employee may be assigned to one or more projects, or may not be assigned to one or more projects. or may not be assigned to a project. A project must have at least one employee assigned, and may have any number of employees assigned. Make sure you identify and include all the elements of an ERD. If you believe that you need to make additional assumptions, clearly state them.