Relational Database management system : PDF

Added on - 14 Jan 2021

  • 22

    Pages

  • 564

    Words

  • 175

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 6 of 22 pages
Relational Database management system
ContentsINTRODUCTION................................................................................................................................................3TASKS................................................................................................................................................................31.Design and draw an ER model for the pizza delivery database.............................................................32.Implement the relational data schemas based on your ER model........................................................53. Solve Queries.....................................................................................................................................20
INTRODUCTIONRelational database management system is a technique for creating an effective and efficientdatabase. This database system useful in the organization for managing all the information in propermanner. This assignment will describe the entity relationship diagram and implementation of databasemanagement system.TASKS1.Design and draw an ER model for the pizza delivery databaseFigure:1
Entity relationship is a graphical representation Database is absolutely an integral part of softwaresystem. To fully utilize ER Diagram in database engineering guarantee you to produce high qualitydatabase design to use in database creation, management and maintenance. An ER model also providesa means for communication. According to figure: 1, there are important entities and attributes discuss ingiven below:Entity:customerAttributes:Customer_idCustomer_nameCustomer_EmailCustomer_phone noCustomer_cityEntity:orderAttributes:Order_idOrder_dateOrder_timeOrder_statusEntity:PizzaAttributes:Pizza_idPizza_namePizza_pricePizza_amountEntity:Non_pizzaAttributes:
N_idN_nameN_amountN_priceEntity:IngredientAttributes:Ingredient_idIngredient_nameIngredient_priceEntity:EmployeeAttributes:Employee_idEmployee_nameEmployee_contact noEmployee_cityEntity:restaurant:Attributes:Street_noStreet_namestuburbThis entity relationship diagram shows the entire entities and attributes that is performing differentspecific role playing in database management system. Customer is relationship with their order. It alsoshows relationship in between them because many customer order variety of pizza. There are importantrelationship representing in the er diagram such asCustomer is relationship with order.They also place order by using online and offline mode.
Employee relationship with order because they will finalize the order of particular person or client.Pizza, non-pizza and order are representing the ISA relationship because they are connected to eachother. They perform specific task and operations in the online pizza ordering system.2.Implement the relational data schemas based on your ER modelFigure: 2This is Entity relationship model of pizza ordering system. They provide specific information regardingthe database management system. It is important for determining the need and requirement ofdatabase. This management system will manage the entire business process in proper manner.
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document