Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need you to write each entity with its data type and the relationship between i need two entity only ( customers - bill) you
i need you to write each entity with its data type and the relationship between
i need two entity only ( customers - bill)
you can see the example below to meet my requirement
Cate_counct, no Qemanne Location Address salary 1.04 Cafe has employce Cashier Lrams Employee ID paswird WERS 1..4 Birthdate o manages , sulary) FA LAAM M date_taken takes Customer Status name Card_info mungon has wa N 1 N M customers takenty orders N (suppier name Henry prepare barista Itemnames Say Date M 1 supplier. In suppliers Contain) M M N 1 Availability pays, supply . items Then ID 1 M item price (supplier, contact ) Weation wes N lill plast quality Produch time produt.price . payment can Lilno bill.care 000 notat cu hare num 2:18 ..Il 4G Back Database 2 3 of 6 IMAM ABDULLMANN ASAL UNIVERSITY System Requirements & Relationship between entities: Relation between employee and sections Each employee can work on one sections but each section can be managed by many employees 1:N Relation between employee and activities Each employee can provide many activities and each activity can be done by many employees N:M Relation between parent and child Each parent can have many but each child can have one purent 1:N Relation between child and food Each child can eat different types of food but each food can be eaten by many children N-M Relation between child and activities Each child can have many activities and each activity can be done by many children N:M Entitics: 1. Child: Since it is a Day care centre the manager will first enter the child information in the system, information that will be provided from the child's parents The manager will enter name, name, Bin Dale, center, Bulding_No, Struel_name, 2:18 Jil 4G Back Database 2 3 Wawr TALLINN COLLECOURS MAMA ANNALIIVITY Entities: 1. Child: : Since it is n Day care centre the manager will first enter the child information in the system, information that will be provided from the child's parents. The manager will enter (ID, Fname, Lname, Birth_Dale, Gender, Building No, Streel name, City name, price, health status). Tventually all of the child data will he saved in the system, Data Type: ID int.PK), Frame String). Laame(String), Birth Datel date). Gender(chum). Building Nofint), StructNameString) City_Name(String), price double). Health Status(string) 2. Employee: The Employee will provide services to the child when they officially register in the Day Care Ceutrc system and the employee has the authority to add and update child's information. Also the employee will have an account to enter his her information ( ID. Frame, Lname, Gender, Social Status, Phone No. Birth Date limail). Data Type: DinL,PK), Frame(slring), Lamellring). Phone No.(int), Birth Date Date),limail(String). genderenum). Social Status enum). 3. Parent: The Parent can have the authority to observe and review the child activities. Also the parent can add their information in the system ( ID, Frame, Lname, Email, password, Workplace, Gender, Phone No) Data Type: Email String).password(string), ID(int,PK), Frame String). LoameString). Workplace(string). Gendercnum), Phonc_No.(int) MAMARUNASAL UNIVERSITY 4. ActivitiesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started