Part 1: Revised ERD and Schema.

Added on - 21 Sep 2019

  • 4

    Pages

  • 1628

    Words

  • 496

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 2 of 4 pages
Part 1: Revised ERD and SchemaThe revised ERD is,Following changes have been made in the revised ERD.The new entity Certificate has been added. It contains the details of the certifications of therestaurants. There is a many to many relationship between Restaurant and Certificate. So, the newassociative entity, RestaurantCertification has been added to the design.The suburb entity has been added. As suburb is an important part of the database, so keeping is asan entity will help in making queries based on suburb, adding relationships with other entities andreducing the chances of errors in the database.Attributes have been added to all entities to add more information.The 3NF relational schema contains the following relations mapped from the revised ERD.CERTIFICATE (CertificateID, CertificateName)RESTAURANT (RestaurantID, RestaurantName, RestaurantDetails, Ethnicity, Street,SuburbID, State, Zipcode, PhoneNumber)RESTAURANT_CERTICATION (RestaurantID,CertificateID, DateCertification)
SUBURB(SuburbID, SuburbName)CUSTOMER (CustomerID, CustomerFirstName, CustomerLastName, PhoneNumber, Street,SuburbID, State, Zipcode)DRIVER(DriverID, DriverFirstName, DriverLastName, Availability,SuburbID)DISH(DishID, DishName, Description, PreparationType, MainIngredients, CourseType,EFRating, CarbonCost, Price, DeliveryTime,RestaurantID)ORDER (OrderID,DriverID,CustomerID, OrderDate, OrderDeliveryTime,ActualDeliveryTime, CurrentStatus)ORDERED_DISH (OrderID,DishID)Part 2: Data DictionaryThe data dictionary is,TableAttributeBrief DescriptionDatatypeand SizeRequiredor NotConstraint(s)ReferentialIntegrityRules (ifAny)CertificateCertificateIDUnique certificatecode.INTYesPrimarykeyCertificateNameName ofcertification.VARCHAR2(50)YesRestaurantRestaurantIDUnique restaurantcode.INTYesPrimarykeyRestaurantNameName of arestaurant.VARCHAR2(50)YesRestaurantDetailsShort descriptionabout the restaurant.VARCHAR2(250)YesEthnicityEthnicity of therestaurant.VARCHAR2(50)YesStreetStreet details.VARCHAR2(250)YesSuburbIDSuburb IDINTYesForeignkeyOn updateStateStatecodeVARCHAR2(3)Yes{NSW,QLD, SA,TAS, VIC,WA}Zipcode4 digit zipcodeCHAR(4)Yes0000-9999PhoneNumber10 digit contactnumber of therestaurant.CHAR(10)Yes0000000000-9999999999Restaurant_CertificationRestaurantIDRestaurant codeINTYesPrimarykey andforeign keyOn updateCertificateIDCertificate codeINTYesPrimarykey andforeign keyOn update
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