Eer diagram

should create an ER DIAGRAM FOR THE DESCRIPTION

The darabase premen you we crearine will be uned by haras- -us no vack the dy-po-dry ceeracont of af thi persera and yoy will subwit the Enhanoed te dagam for tha anigenent. You ewit use the Croer) Foot notation trom our lectures and Chapters 15 to cemplete this deifh. Pietas 4 th: The most obrous thing that needs to be traded as part of this databese arcte is the intormation abour lareel. A puas has an asociated price and cout to the company boch of which are detenmined by the int af the pira and the toppngs en the pira A pura can be in two atatec complatid by the ktrhen or atil beine proceiked by the kitchen. Fach piraa can have muliple tropings. Tach toopirs har a nane a prier bo the castemer, a price to the butiness, an amount used for eadh pira side, a mitiminum invertary level, and a current inventory level fahich is spdated whenever a pura is ordenedl. The same topping can be toppine. which is alwim a dovble amount, Deetse counts as a toppine ettere in no free cheses in thit arganiation). on it Cach order has a total cost to fte buiness which is calculated by adsind we the costs of each perma Each order should have a timestamp for when the food was ordered (wo the kinchen can proritase onderal Cach order also has a total prise te the customer, which is cakilated by adding the prices of each plas it be ocder it for a dine in eusaomer, then ne need to know ile table number. ff an order is for pickup, then it neceds to have a pichup curtemer asiociated wate. That evatemer mut have a ratre atd a phone number, if an order is for delivery, then ie mest bave a delhever customer assecitid with in and inclube a name, phose number and addrew. A cultomer can have many ordens yince the inlometion is sared for the neat time they order patza. A custamer could have some pichpo orders, and some delvery araers. While other pirta plates might allow a cuttomer to tene multiple addresies, Plasas-a-Us only allows a customes to hive one address. Avte, we dont need any oultemer intormation for a dine in castome When despenine voor databise, the type of order shovld be used as your discriminator. Furthermore, Raras-tis ofless docounti Bncounti can be appled to indididel pasias or an entere order, Disteunts have a riame and nither a dollar amount off er a pereentagr of. A pitat or onder can have mulipit ditcounes appled to in, and a Gscourt can te apples to masy peras er arden. The penera aleo needr to treck some base ponces for their pearas. Each pima newds a hase price, a cnut trpe, a slie, and a base cost. To compute the price al a plaze. you wovld iock at the alat and enit of the pira and find the cocreponding base price, Then to that you would add the price for each toppire on the pirza. Finaly. roe would apply any dicourss so the pura. To find the total for the order, you would ast up the price for each plas, theo apply any dacounts thit apely to the order. Whis the base pries ar topping prices could change over tirbe, those changes should not be vethected in pust orders lo, a pirzis price shovid be calculuned once and laved. To find the cost of a piana to the businevs, the same process s used, with itats instead of arices. Dacounts do net lewer the eust at the ender to a binines The puraria s under new management and will be very douing montaring proftablity. To make this reports (aka views) on: popular to leiat pepulur - Eipft hy Birn a summary of the probit by petra sice and orus tipe ever a velectied time periad ondered by perit from mest prefitatie to least profitabie - Broff by Quder Tyee a summary of the profn lor each of the livee troes of ordes by month =ith a grand totat ever all the ender at the paseria The tables you create must contain all the imloemution you need to antite the views above: More detah an the viems will coene in Part 2 . The vieks will be used in Pant 3 mo gmerite the sepors defined above. Notes: Nowhere in this promst dees is mention a unigue ib or arimary ary for any of these entitiec. This is becinet your cutaomer it urfamiliat wich databaies and doei not know that primury limh ant importart. Be iure need to properly represect the MM relation shipt tothes is a conceptual desen of the databavel. Given your dient's lack of knowlider about database, there may be ocher thines wew need ns incerpen at welt. For instance, from your ebent's vienpoint the dstinction between a eastomer and an onder com be fuaty. for each intrbute carefuly eonsider whether that is informutian aboue she arder ar abeat ene cuttates, Your clent may atse provide eitra informition that may not be directly thewn in the th diaeram (Ibe some of the detals about ham pricine is determined) lut will eve vou at abea af how the infoemution will be used. Feel free to akk follow ag quastion it yemething is unckear. The darabase premen you we crearine will be uned by haras- -us no vack the dy-po-dry ceeracont of af thi persera and yoy will subwit the Enhanoed te dagam for tha anigenent. You ewit use the Croer) Foot notation trom our lectures and Chapters 15 to cemplete this deifh. Pietas 4 th: The most obrous thing that needs to be traded as part of this databese arcte is the intormation abour lareel. A puas has an asociated price and cout to the company boch of which are detenmined by the int af the pira and the toppngs en the pira A pura can be in two atatec complatid by the ktrhen or atil beine proceiked by the kitchen. Fach piraa can have muliple tropings. Tach toopirs har a nane a prier bo the castemer, a price to the butiness, an amount used for eadh pira side, a mitiminum invertary level, and a current inventory level fahich is spdated whenever a pura is ordenedl. The same topping can be toppine. which is alwim a dovble amount, Deetse counts as a toppine ettere in no free cheses in thit arganiation). on it Cach order has a total cost to fte buiness which is calculated by adsind we the costs of each perma Each order should have a timestamp for when the food was ordered (wo the kinchen can proritase onderal Cach order also has a total prise te the customer, which is cakilated by adding the prices of each plas it be ocder it for a dine in eusaomer, then ne need to know ile table number. ff an order is for pickup, then it neceds to have a pichup curtemer asiociated wate. That evatemer mut have a ratre atd a phone number, if an order is for delivery, then ie mest bave a delhever customer assecitid with in and inclube a name, phose number and addrew. A cultomer can have many ordens yince the inlometion is sared for the neat time they order patza. A custamer could have some pichpo orders, and some delvery araers. While other pirta plates might allow a cuttomer to tene multiple addresies, Plasas-a-Us only allows a customes to hive one address. Avte, we dont need any oultemer intormation for a dine in castome When despenine voor databise, the type of order shovld be used as your discriminator. Furthermore, Raras-tis ofless docounti Bncounti can be appled to indididel pasias or an entere order, Disteunts have a riame and nither a dollar amount off er a pereentagr of. A pitat or onder can have mulipit ditcounes appled to in, and a Gscourt can te apples to masy peras er arden. The penera aleo needr to treck some base ponces for their pearas. Each pima newds a hase price, a cnut trpe, a slie, and a base cost. To compute the price al a plaze. you wovld iock at the alat and enit of the pira and find the cocreponding base price, Then to that you would add the price for each toppire on the pirza. Finaly. roe would apply any dicourss so the pura. To find the total for the order, you would ast up the price for each plas, theo apply any dacounts thit apely to the order. Whis the base pries ar topping prices could change over tirbe, those changes should not be vethected in pust orders lo, a pirzis price shovid be calculuned once and laved. To find the cost of a piana to the businevs, the same process s used, with itats instead of arices. Dacounts do net lewer the eust at the ender to a binines The puraria s under new management and will be very douing montaring proftablity. To make this reports (aka views) on: popular to leiat pepulur - Eipft hy Birn a summary of the probit by petra sice and orus tipe ever a velectied time periad ondered by perit from mest prefitatie to least profitabie - Broff by Quder Tyee a summary of the profn lor each of the livee troes of ordes by month =ith a grand totat ever all the ender at the paseria The tables you create must contain all the imloemution you need to antite the views above: More detah an the viems will coene in Part 2 . The vieks will be used in Pant 3 mo gmerite the sepors defined above. Notes: Nowhere in this promst dees is mention a unigue ib or arimary ary for any of these entitiec. This is becinet your cutaomer it urfamiliat wich databaies and doei not know that primury limh ant importart. Be iure need to properly represect the MM relation shipt tothes is a conceptual desen of the databavel. Given your dient's lack of knowlider about database, there may be ocher thines wew need ns incerpen at welt. For instance, from your ebent's vienpoint the dstinction between a eastomer and an onder com be fuaty. for each intrbute carefuly eonsider whether that is informutian aboue she arder ar abeat ene cuttates, Your clent may atse provide eitra informition that may not be directly thewn in the th diaeram (Ibe some of the detals about ham pricine is determined) lut will eve vou at abea af how the infoemution will be used. Feel free to akk follow ag quastion it yemething is unckear. You will submit an electronic copy of your solution as a PDF file on Canvas by the due date. No late assignments will be accepted. You must use a diagramming tool to create your diagrams (such as draw.io or LucidChart). Do not submit the source file, export your document to PDF format and submit the.pdf file to Canvas. Hand drawn diagrams, even if scanned in, will not be accepted. If you find another diagramming tool, make sure you follow the notation used in this course. There are alternative notation styles out there that other tools may use for ER diagrams, but for this course we will only use the notation and style shown in Chapters 4&5. The darabase premen you we crearine will be uned by haras- -us no vack the dy-po-dry ceeracont of af thi persera and yoy will subwit the Enhanoed te dagam for tha anigenent. You ewit use the Croer) Foot notation trom our lectures and Chapters 15 to cemplete this deifh. Pietas 4 th: The most obrous thing that needs to be traded as part of this databese arcte is the intormation abour lareel. A puas has an asociated price and cout to the company boch of which are detenmined by the int af the pira and the toppngs en the pira A pura can be in two atatec complatid by the ktrhen or atil beine proceiked by the kitchen. Fach piraa can have muliple tropings. Tach toopirs har a nane a prier bo the castemer, a price to the butiness, an amount used for eadh pira side, a mitiminum invertary level, and a current inventory level fahich is spdated whenever a pura is ordenedl. The same topping can be toppine. which is alwim a dovble amount, Deetse counts as a toppine ettere in no free cheses in thit arganiation). on it Cach order has a total cost to fte buiness which is calculated by adsind we the costs of each perma Each order should have a timestamp for when the food was ordered (wo the kinchen can proritase onderal Cach order also has a total prise te the customer, which is cakilated by adding the prices of each plas it be ocder it for a dine in eusaomer, then ne need to know ile table number. ff an order is for pickup, then it neceds to have a pichup curtemer asiociated wate. That evatemer mut have a ratre atd a phone number, if an order is for delivery, then ie mest bave a delhever customer assecitid with in and inclube a name, phose number and addrew. A cultomer can have many ordens yince the inlometion is sared for the neat time they order patza. A custamer could have some pichpo orders, and some delvery araers. While other pirta plates might allow a cuttomer to tene multiple addresies, Plasas-a-Us only allows a customes to hive one address. Avte, we dont need any oultemer intormation for a dine in castome When despenine voor databise, the type of order shovld be used as your discriminator. Furthermore, Raras-tis ofless docounti Bncounti can be appled to indididel pasias or an entere order, Disteunts have a riame and nither a dollar amount off er a pereentagr of. A pitat or onder can have mulipit ditcounes appled to in, and a Gscourt can te apples to masy peras er arden. The penera aleo needr to treck some base ponces for their pearas. Each pima newds a hase price, a cnut trpe, a slie, and a base cost. To compute the price al a plaze. you wovld iock at the alat and enit of the pira and find the cocreponding base price, Then to that you would add the price for each toppire on the pirza. Finaly. roe would apply any dicourss so the pura. To find the total for the order, you would ast up the price for each plas, theo apply any dacounts thit apely to the order. Whis the base pries ar topping prices could change over tirbe, those changes should not be vethected in pust orders lo, a pirzis price shovid be calculuned once and laved. To find the cost of a piana to the businevs, the same process s used, with itats instead of arices. Dacounts do net lewer the eust at the ender to a binines The puraria s under new management and will be very douing montaring proftablity. To make this reports (aka views) on: popular to leiat pepulur - Eipft hy Birn a summary of the probit by petra sice and orus tipe ever a velectied time periad ondered by perit from mest prefitatie to least profitabie - Broff by Quder Tyee a summary of the profn lor each of the livee troes of ordes by month =ith a grand totat ever all the ender at the paseria The tables you create must contain all the imloemution you need to antite the views above: More detah an the viems will coene in Part 2 . The vieks will be used in Pant 3 mo gmerite the sepors defined above. Notes: Nowhere in this promst dees is mention a unigue ib or arimary ary for any of these entitiec. This is becinet your cutaomer it urfamiliat wich databaies and doei not know that primury limh ant importart. Be iure need to properly represect the MM relation shipt tothes is a conceptual desen of the databavel. Given your dient's lack of knowlider about database, there may be ocher thines wew need ns incerpen at welt. For instance, from your ebent's vienpoint the dstinction between a eastomer and an onder com be fuaty. for each intrbute carefuly eonsider whether that is informutian aboue she arder ar abeat ene cuttates, Your clent may atse provide eitra informition that may not be directly thewn in the th diaeram (Ibe some of the detals about ham pricine is determined) lut will eve vou at abea af how the infoemution will be used. Feel free to akk follow ag quastion it yemething is unckear. The darabase premen you we crearine will be uned by haras- -us no vack the dy-po-dry ceeracont of af thi persera and yoy will subwit the Enhanoed te dagam for tha anigenent. You ewit use the Croer) Foot notation trom our lectures and Chapters 15 to cemplete this deifh. Pietas 4 th: The most obrous thing that needs to be traded as part of this databese arcte is the intormation abour lareel. A puas has an asociated price and cout to the company boch of which are detenmined by the int af the pira and the toppngs en the pira A pura can be in two atatec complatid by the ktrhen or atil beine proceiked by the kitchen. Fach piraa can have muliple tropings. Tach toopirs har a nane a prier bo the castemer, a price to the butiness, an amount used for eadh pira side, a mitiminum invertary level, and a current inventory level fahich is spdated whenever a pura is ordenedl. The same topping can be toppine. which is alwim a dovble amount, Deetse counts as a toppine ettere in no free cheses in thit arganiation). on it Cach order has a total cost to fte buiness which is calculated by adsind we the costs of each perma Each order should have a timestamp for when the food was ordered (wo the kinchen can proritase onderal Cach order also has a total prise te the customer, which is cakilated by adding the prices of each plas it be ocder it for a dine in eusaomer, then ne need to know ile table number. ff an order is for pickup, then it neceds to have a pichup curtemer asiociated wate. That evatemer mut have a ratre atd a phone number, if an order is for delivery, then ie mest bave a delhever customer assecitid with in and inclube a name, phose number and addrew. A cultomer can have many ordens yince the inlometion is sared for the neat time they order patza. A custamer could have some pichpo orders, and some delvery araers. While other pirta plates might allow a cuttomer to tene multiple addresies, Plasas-a-Us only allows a customes to hive one address. Avte, we dont need any oultemer intormation for a dine in castome When despenine voor databise, the type of order shovld be used as your discriminator. Furthermore, Raras-tis ofless docounti Bncounti can be appled to indididel pasias or an entere order, Disteunts have a riame and nither a dollar amount off er a pereentagr of. A pitat or onder can have mulipit ditcounes appled to in, and a Gscourt can te apples to masy peras er arden. The penera aleo needr to treck some base ponces for their pearas. Each pima newds a hase price, a cnut trpe, a slie, and a base cost. To compute the price al a plaze. you wovld iock at the alat and enit of the pira and find the cocreponding base price, Then to that you would add the price for each toppire on the pirza. Finaly. roe would apply any dicourss so the pura. To find the total for the order, you would ast up the price for each plas, theo apply any dacounts thit apely to the order. Whis the base pries ar topping prices could change over tirbe, those changes should not be vethected in pust orders lo, a pirzis price shovid be calculuned once and laved. To find the cost of a piana to the businevs, the same process s used, with itats instead of arices. Dacounts do net lewer the eust at the ender to a binines The puraria s under new management and will be very douing montaring proftablity. To make this reports (aka views) on: popular to leiat pepulur - Eipft hy Birn a summary of the probit by petra sice and orus tipe ever a velectied time periad ondered by perit from mest prefitatie to least profitabie - Broff by Quder Tyee a summary of the profn lor each of the livee troes of ordes by month =ith a grand totat ever all the ender at the paseria The tables you create must contain all the imloemution you need to antite the views above: More detah an the viems will coene in Part 2 . The vieks will be used in Pant 3 mo gmerite the sepors defined above. Notes: Nowhere in this promst dees is mention a unigue ib or arimary ary for any of these entitiec. This is becinet your cutaomer it urfamiliat wich databaies and doei not know that primury limh ant importart. Be iure need to properly represect the MM relation shipt tothes is a conceptual desen of the databavel. Given your dient's lack of knowlider about database, there may be ocher thines wew need ns incerpen at welt. For instance, from your ebent's vienpoint the dstinction between a eastomer and an onder com be fuaty. for each intrbute carefuly eonsider whether that is informutian aboue she arder ar abeat ene cuttates, Your clent may atse provide eitra informition that may not be directly thewn in the th diaeram (Ibe some of the detals about ham pricine is determined) lut will eve vou at abea af how the infoemution will be used. Feel free to akk follow ag quastion it yemething is unckear. You will submit an electronic copy of your solution as a PDF file on Canvas by the due date. No late assignments will be accepted. You must use a diagramming tool to create your diagrams (such as draw.io or LucidChart). Do not submit the source file, export your document to PDF format and submit the.pdf file to Canvas. Hand drawn diagrams, even if scanned in, will not be accepted. If you find another diagramming tool, make sure you follow the notation used in this course. There are alternative notation styles out there that other tools may use for ER diagrams, but for this course we will only use the notation and style shown in Chapters 4&5