Note: Use the database requirements document created in Lab 3-1 to build the ER diagram. In this lab, do not attempt to show the relationships between the entities. This will be covered in the next lab. Also, do not attempt to resolve any anomalies that you may recognize at this point. Resolving anomalies will be part of a later lab.

1. Using the requirements document previously created, create an ER diagram for the ProAudio database. Review the document and the enterprise requirements to ensure that all the entities identified to this point are included in the ER diagram.
2. As you create your ER model, attempt to identify the various data types that the attribute's values will have. Remember, typically an ER diagram will not contain attribute domains, but it is necessary to identify and record the domains for the various attributes in a separate document. Also, attempt to identify candidate keys for each entity.

Note: We have provided a sample solution of the lab in the download files.

c_city - VARCHAR, c_state - VARCHAR, c_zip - VARCHAR, c_phone - VARCHAR, c_cc_num - VARCHAR, c_exp_date - VARCHAR) Distributors(*d num - INTEGER, d_name - VARCHAR, d_street - VARCHAR, d_city - VARCHAR, d state - VARCHAR, d_zip - VARCHAR, d phone - VARCHAR, d_contact - VARCHAR, d_contact_extension - INTEGER) Orders(*o_num - INTEGER, *c_num - INTEGER, s num - INTEGER, o_date - DATE, o_filled - VARCHAR (Boolean)) Items(*i_num - INTEGER, i title - VARCHAR, d num - INTEGER, i price - DECIMAL, i release_date - DATE, i_genre - VARCHAR) Musicians(*m_num - INTEGER, m_first_name - VARCHAR, m_last_name - VARCHAR) Producers(*p_num - INTEGER, p first name - VARCHAR, p_last_name - VARCHAR) Sale Reps(*s_num - INTEGER, s_first_name - VARCHAR, s_last_name - VARCHAR) Locations(*1_num - INTEGER, 1 street - VARCHAR, 1_city - VARCHAR, 1_state - VARCHAR, l_zip - VARCHAR, 1_phone - VARCHAR, 1_fax - VARCHAR) c_city - VARCHAR, c_state - VARCHAR, c_zip - VARCHAR, c_phone - VARCHAR, c_cc_num - VARCHAR, c_exp_date - VARCHAR) Distributors(*d num - INTEGER, d_name - VARCHAR, d_street - VARCHAR, d_city - VARCHAR, d state - VARCHAR, d_zip - VARCHAR, d phone - VARCHAR, d_contact - VARCHAR, d_contact_extension - INTEGER) Orders(*o_num - INTEGER, *c_num - INTEGER, s num - INTEGER, o_date - DATE, o_filled - VARCHAR (Boolean)) Items(*i_num - INTEGER, i title - VARCHAR, d num - INTEGER, i price - DECIMAL, i release_date - DATE, i_genre - VARCHAR) Musicians(*m_num - INTEGER, m_first_name - VARCHAR, m_last_name - VARCHAR) Producers(*p_num - INTEGER, p first name - VARCHAR, p_last_name - VARCHAR) Sale Reps(*s_num - INTEGER, s_first_name - VARCHAR, s_last_name - VARCHAR) Locations(*1_num - INTEGER, 1 street - VARCHAR, 1_city - VARCHAR, 1_state - VARCHAR, l_zip - VARCHAR, 1_phone - VARCHAR, 1_fax - VARCHAR)