Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed

you can see the example below to meet my requirement

image text in transcribed

image text in transcribed

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. Activities

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Driven Web Sites

Authors: Joline Morrison, Mike Morrison

2nd Edition

? 061906448X, 978-0619064488

More Books

Students also viewed these Databases questions