0 LIKES LikeUnLike
how we can draw entity relation diagram for airline reservation
Tags: Airline, diagram, draw, entity, relation, reservation
Report (1) (0) | 12 years, 7 month(s) ago
6. A company purchases products and sells them to it's customers. Each time a sale occurs, an invoice is created listing the customer name, and a list of purchase product descriptions, the supplier name for the products, and the price of each product. The product number identifies each product and will appear again if another customer purchases the same product. Each supplier can supply many products which we can sell, but each product has only one supplier.
ABC Playschool is a child daycare centre. A parent registers their child or children at the school using a registration form. A parent can submit more than one registration form. Each room in the daycare is assigned an age group. For example an infant is under 1 year of age and toddlers are from 1 to 3 years of age. A child is assigned to a room based on their age and availability of space. A room may be assigned one or more employees. An employee can only be assigned to one room. The minimum number of employees required for a room is determined by the number of children assigned to the room and the child:staff ratio identified by the government. For example one employee can care for 5 infants or 8 toddlers. 1. Prepare an Entity Relationship Diagram for ABC Daycare Centre. Considering following instructions For each entity indicate the primary key by underlining attribute(s) making up primary key and also specify at least 1 additional significant attribute. Identify and label significant relationships between pairs of entities (either 1:1, 1 : M or M:N). 2. Prepare necessary tables and link them using DBMS methodologies 3. Normalize all the tables 4. Create a database and tables to store data of ABC Playschool. 5. Verify your database accuracy by applying sample data
Report (0) (0) | 12 years, 7 month(s) ago
Latest activity: 13 years, 2 month(s) ago. This question has 4 answers.