Discuss About The Database Concepts And Framework (Free Assignment Sample)

Question:

Discuss about the Database Concepts and framework.

Answer:

Entity Relationship Diagram

Figure 1: Entity Relationship Diagram

(Source: Created by author)

Business Rule

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.

Normalization

The database is in t 3^rd 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

Bibliography

Ambler, S., 2012. Agile database techniques: Effective strategies for the agile software developer. John Wiley & Sons.

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.

Download Now

Upto 50% OFF

Order Now

Why Student Prefer Us ?

Top quality papers

We do not compromise when it comes to maintaining high quality that our customers expect from us. Our quality assurance team keeps an eye on this matter.

100% affordable

We are the only company in UK which offers qualitative and custom assignment writing services at low prices. Our charges will not burn your pocket.

Timely delivery

We never delay to deliver the assignments. We are very particular about this. We assure that you will receive your paper on the promised date.

Round the clock support

We assure 24/7 live support. Our customer care executives remain always online. You can call us anytime. We will resolve your issues as early as possible.

Privacy guaranteed

We assure 100% confidentiality of all your personal details. We will not share your information. You can visit our privacy policy page for more details.