Bonanza Offer FLAT 20% off & $20 sign up bonus Order Now
Figure 1: Entity Relationship Diagram
(Source: Created by author)
In a database framework, business guidelines are utilized to depict the characteristics property. Each database framework keeps up the business principle during the time of creating database. For this situation, the business guideline is overseen legitimately. The diagram for Entity relationship is planned by supporting the business database standard. Some supposition made by the database designer, for example, NOC element is utilized as a part for creating diagram in context to Entity Relationship. Here NOC (No Objection Certificate) is utilized to confirm that no different individuals have any complaint about any parts. Additionally, the properties of NOC are accepted. In the above ERD, the entity advertisement is utilized to store details of the sponsor. Since to build something in a load, the general population need to take authorization from the committee and gathering, promote this application to illuminate the NOC. The zone can be isolated into numerous sorts. To keep up an appropriately standardized database, the engineer utilized the distinctive kind of range substance and put away the zone subtle elements into it. Same as region, parts have a wide range of sorts. The database engineer utilized this parcel sort substance to store the part points of interest according to their sorts. Here the part procedure element is likewise expected. To keep up the business control the designer use parcel process element. In addition, in the parcel procedure substance, part handle data ascribe to store the points of interest of the preparing strategy and their subtle elements.
The database is in t 3rd normal form. The tables are given bellow:
Investigationinspector
Name | DataType | Constraints |
investigationinspectorid | int(10) | PK |
investigationinsname | varchar(255) |
|
investigationinspectorcontaact | int(15) |
|
investigationinsinfo | varchar(255) |
|
Promotion
Name | DataType | Constraints |
promotionid | int(10) | PK |
promotionname | varchar(255) |
|
promotiondate | date |
|
promotiondetails | varchar(350) |
|
promotiontypeid | int(10) | FK (promotiontype.promotionareaid) |
promotiontypeadtypid | int(10) | FK (promotiontype.promotiontypid) |
Promotiontype
Name | DataType | Constraints | Nullable | Description |
promotiontypid | int(10) | PK | No |
|
promotionid | int(10) |
| No |
|
promotionareaid | int(10) | PK/FK (region.regionaid) | No |
|
promotioninfo | varchar(200) |
| No |
|
promotioncontact | int(15) |
| No |
|
region
Name | DataType | Constraints | Nullable | Description |
regionaid | int(10) | PK | No |
|
regionname | varchar(255) |
| No |
|
regionloc | varchar(255) |
| No |
|
regionsupervisorid | int(10) | FK (regionsupervisor.regionsupervisorid) | No |
|
regiondetails | varchar(255) |
| No |
|
regionsize | varchar(255) |
| No |
|
regiontypeid | int(10) | FK (regiontype.regiontypeid) | No |
|
obstructarea | int(1) |
| No |
|
regionareaid | int(10) | FK (obstructareatype.obstructareatypid) | No |
|
Lotlandlowner
Name | DataType | Constraints | Nullable | Description |
landlownerid | int(10) | PK | No |
|
landlownername | varchar(255) |
| No |
|
landlownercontactno | int(10) |
| No |
|
andlownerinfo | int(10) |
| No |
|
Builder
Name | DataType | Constraints | Nullable | Description |
builderid | int(10) | PK | No |
|
buildertype | int(10) | FK (buildertype.builderid) | No |
|
builderplotid | int(10) | PK | No |
|
buildername | varchar(255) |
| No |
|
builderplotslotid | int(10) | FK (lot_des.lot_desid) | No |
|
builderdesid | int(10) | FK (builderinfo.builderinfoid) | No |
|
Cleranceentry
Name | DataType | Constraints | Nullable | Description |
cleranceentryid | int(10) | PK | No |
|
cleranceentryname | varchar(255) |
| No |
|
cleranceentryarea | varchar(255) |
| No |
|
cleranceentrylot | varchar(255) |
| No |
|
cleranceentrycleranceentrystatus | varchar(255) |
| No |
|
cleranceentryinfo | varchar(255) |
| No |
|
Objectionaccessor
Name | DataType | Constraints | Nullable | Description |
accessorid | int(10) | PK | No |
|
accessorname | varchar(255) |
| No |
|
accessortyp | varchar(255) |
| No |
|
accessorcontact | int(15) |
| No |
|
Plotobjection
Name | DataType | Constraints | Nullable | Description |
plotobjection | int(10) | PK | No |
|
plotobjectiondate | date |
| No |
|
plotobjectionissue | varchar(200) |
| No |
|
reportingpersonid | int(10) | FK (objectionaccessor.accessorid) | No |
|
plotobjectiontypeid | int(10) | FK (plotobjtyp.plotobjtypid) | No |
|
Regiontype
Name | DataType | Constraints | Nullable | Description |
regiontypeid | int(10) | PK | No |
|
regiontypename | varchar(255) |
| No |
|
regiondescripton | varchar(255) |
| No |
|
Regionsupervisor
Name | DataType | Constraints | Nullable | Description |
regionsupervisorid | int(10) | PK | No |
|
regionsupervisoridname | varchar(255) |
| No |
|
regionid | int(10) |
| No |
|
regioncontactno | int(10) |
| No |
|
Buildertype
Name | DataType | Constraints | Nullable | Description |
builderid | int(10) | PK | No |
|
buildertypename | varchar(255) |
| No |
|
buildertypinfo | varchar(255) |
| No |
|
Lot_des
Name | DataType | Constraints | Nullable | Description |
lot_desid | int(10) | PK | No |
|
lotname | varchar(255) |
| No |
|
regionid | int(10) |
| No |
|
lotareainfo | int(10) | FK (plotcollectionpolicy.policysid) | No |
|
lotvolume | varchar(255) |
| No |
|
lotownerid | int(10) | FK (lotlandlowner.landlownerid) | No |
|
plottype | int(10) |
| No |
|
plottypeid | int(10) | FK (lotspcification.lotspcid) | No |
|
Plotobjtyp
Name | DataType | Constraints | Nullable | Description |
plotobjtypid | int(10) | PK | No |
|
plotobjtype | varchar(150) |
| No |
|
plotobjsub | varchar(255) |
| No |
|
plotobjautho | varchar(100) |
| No |
|
Lotspcification
Name | DataType | Constraints | Nullable | Description |
lotspcid | int(10) | PK | No |
|
lotspcname | varchar(255) |
| No |
|
lotspcinfo | varchar(255) |
| No |
|
policyprocid | int(10) |
| No |
|
Plotcollectionpolicy
Name | DataType | Constraints | Nullable | Description |
policysid | int(10) | PK | No |
|
policyname | varchar(255) |
| No |
|
processpolicyinfo | varchar(255) |
| No |
|
Obstructareatype
Name | DataType | Constraints | Nullable | Description |
obstructareatypid | int(10) | PK | No |
|
obstructareatypename | varchar(255) |
| No |
|
obstructareainfo | varchar(255) |
| No |
|
Obojectiondetails
Name | DataType | Constraints | Nullable | Description |
nobid | int(10) | PK | No |
|
nobname | varchar(255) |
| No |
|
plotobjid | int(10) | FK (plotobjection.plotobjection) | No |
|
certautho | varchar(255) |
| No |
|
certinfo | varchar(255) |
| No |
|
Clearancecheck
Name | DataType | Constraints | Nullable | Description |
clearancecheckid | int(10) | PK | No |
|
clearancenid | int(10) | FK (cleranceentry.cleranceentryid) | No |
|
noccerid | int(10) |
| No |
|
checkoutcome | varchar(255) |
| No |
|
statement | varchar(255) |
| No |
|
invinspectorid | int(10) | FK (investigationinspector.investigationinspectorid) | No |
|
Obstructarea
Name | DataType | Constraints | Nullable | Description |
obstructareaid | int(10) | PK | No |
|
obstructarealoc | varchar(255) |
| No |
|
obstructareasize | varchar(255) |
| No |
|
obstructareatypeid | int(10) | FK (obstructareatype.obstructareatypid) | No |
|
Builderinfo
Name | DataType | Constraints | Nullable | Description |
builderinfoid | int(10) | PK | No |
|
builderreputation | varchar(255) |
| No |
|
builderexp | varchar(255) |
| No |
|
builderontactno | int(15) |
| No |
|
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management. Cengage Learning.
Grefen, P., Pernici, B. and Sánchez, G. eds., 2012. Database support for workflow management: the WIDE project (Vol. 491). Springer Science & Business Media.
Herbst, H., 2012. Business rule-oriented conceptual modeling. Springer Science & Business Media.
Thalheim, B., 2013. Entity-relationship modeling: foundations of database technology. Springer Science & Business Media.
Upload your Assignment and improve Your Grade
Boost Grades