Need Conceptual Models on all of the following scenarios.

Steve operates a cinema chain and has given you the following information:

I have many cinemas. Each cinema can have many theaters. Movies are shown throughout the day starting at 11 am and finishing at 1 am. Each movie is given a 2-hour time slot. We never show a movie in more than one theater at a time, but we do shifts movies among theaters because seating capacity varies. I am interested in knowing how many people, classified by adults and children, attend each showing of a movie. I vary ticket prices by movie and time slot.

.At SalesRUs, invoices are written by sales reps. Each sales representative can write many invoices, but each invoice is written by a single sales representative. An invoice is written for a single customer, however each customer can have many invoices. An invoice can include many detail lines which describe the products bought by the customer. Products are supplied by different vendors.

.A database for a local garage is needed. The database contains data items for a customer account number, the customers name, the customers address, the customers work telephone number, the customers home telephone number, date of work done, automobile make, automobile model, description of work done, parts needed to complete the work, charge for parts needed, and charge for labor performed. For warranty reasons, data must be maintained in the database for at least ninety days; therefore, a customer may have several records in the database at any particular time. Identical parts have only one cost, but different parts have different costs (for example, all tires cost the same and all engines cost the same, but a tire and an engine do not cost the same). A customer may have more than one car. Draw the ER diagram to model these data relationships.

Working with less information

Consider a simple course enrollment database for use by the Department of Management in the CBA. The department offers several courses. At the beginning of the semester the Department Chair assigns an instructor to each course and publishes a directory listing course and instructor office. By the 3rd week the department produces a course roll for its own records. At the end of the semester the instructor posts grades for each student in the course for that semester.

Mary Richards owns a house painting company. She has decided that she needs a better record-keeping system that can be used to quickly retrieve information about her current and former customers, such as their name and phone number. She already has detailed data about the individual jobs that her company has done for these customers, such as the job number, the beginning and end dates of the job, a brief description of the job, and the amount billed. However, Mary would like to be able to easily relate this data to the jobs customer and to her employees who worked on the job. Each job has a foreman and several other painters on it. She also has information about all of her employees (their SSN, their name, their salary and their phone number). Sometimes an employee will be a painter on one job and a foreman on another. When a customer calls with a complaint about the work being done on their house Mary needs to be able to determine who is or was the foreman on the job and who else worked on the job.

Often times customers are referred by other customers, Mary thinks it would be a good idea to store data about the referral sources. When a customer refers another customer Mary sends $10 to the referring customer with a thank you note. Mary doesnt recognize multiple referral sources for an individual customer and she has no interest in storing data on the self-referrals. Of course a customer may refer many other customers to Mary.

Each semester, each student must be assigned an advisor who counsels students about degree requirements and helps students register for class. Each student must register for class with the help of an advisor, but if the assigned advisor is not available, the student may register with any advisor. We must keep track of the students, assigned advisors, and name of advisor with whom the student registered in the most recent semester.

Working from the bottom up

.Convert the following to a conceptual model.

Branch Name	Cust. #	Account #	Trans. #	Trans. Date	Cust. Name	Trans. Amount	Account Type	Branch Phone	Customer Phone
Central	10010	000-001	3001	02/01/93	Jones, Sam	100.00	Checking	555-0100	555-0105
Central	10010	000-002	3055	02/01/93	Jones, Sam	25.00	Savings	555-0100	555-0105
Central	10010	000-021	3056	02/01/93	Jones, Sam	-52.50	Checking	555-0100	555-0105
Central	10010	000-033	3057	02/02/93	Jones, Sam	1500.00	CD	555-0100	555-0105
Central	10010	000-003	3058	02/02/93	Jones, Sam	100.00	Safe Deposit	555-0100	555-0105
Eastside	10020	000-009	3006	02/02/93	Abrams, Max	2599.00	Checking	555-0109	555-2204
Westlake	10020	000-009	3007	02/02/93	Abrams, Max	-25.00	Checking	555-4232	555-2204
Eastside	10020	000-009	3008	02/03/93	Abrams, Max	-10.00	Checking	555-0109	555-2204
Central	10030	000-006	3012	02/03/93	Cohen, Esther	198.00	Checking	555-0100	555-0039
Central	10040	000-010	3010	02/03/93	Khan, Satya	-824.00	Savings	555-0100	555-1001
Central	10040	000-010	3011	02/03/93	Khan, Satya	-115.00	Savings	555-0100	555-1001
Westlake	10010	000-004	3081	02/03/93	Jones, Sam	190.25	Loan	555-4232	555-0105
Westlake	10050	000-018	3013	02/03/93	Brown, Judy	198.00	Checking	555-4232	555-9900
Central	10050	000-018	3014	02/03/93	Brown, Judy	-165.99	Checking	555-0100	555-9900
Westlake	10050	000-005	3015	02/03/93	Brown, Judy	25.00	Loan	555-4232	555-9900
Eastside	10060	000-012	3044	02/04/93	Wales, Minnie	-40.99	Checking	555-0109	555-0033
Eastside	10070	000-027	3017	02/04/93	Smith, Stan	-886.00	Savings	555-0109	555-1250
Westlake	10070	000-027	3018	02/04/93	Smith, Stan	100.00	Savings	555-4232	555-1250

Unary Relationships

Assume that at Pine Valley Furniture each product (described by product number, description, and cost) is comprised of at least three components (described by component number, description, and unit of measure) and components are used to make one or many products. In addition, assume components are used to make other components, and that raw materials are also considered components.