Question $2$

As stated in the case, Skyworth follows the DBLC to guide the design of the database. Currently, the

database team is engaged in the conceptual design stage. During this stage, data modelling is

utilised to create an abstract database structure that accurately represents the real$-$world objects.

The conceptual model must reflect a clear understanding of the business and its functional area.

Sanjay assigns various data modelling tasks to you, which can be completed using drawings or

drawing software. It is important to note that the models generated during the conceptual design

stage are hardware and software independent.

$2\mathrm{.}1.$ At the Table Mountain Shopping Centre located in Cape Town CBD$,$ Siya Khumalo and

Deacon Willemse are Heads of Maintenance $($HOM$).$ Their duties include managing the

parking attendance, the car wash and general maintenance and upkeep of the shopping

centre premises and infrastructure. Siya and Deacon will be responsible for issuing the POS

devices to parking lot staff before their shift starts. This process is defined by the following

business rule: An HOM may check out many POSs, and a POS may be checked out by many

parking area staff. Additionally, the following observations inform the business rules: a

parking area employee is not required to check out a POS device because parking area

employees work in shifts, and a POS device does not need to be checked out to exist in

inventory. After consulting$|$ with your fellow database administrators, you observe that the

business rule is best captured in a composite entity relationship diagram $($ERD$).$ For an

example, see Figure $11\mathrm{.}2$ on page $585$ of Coronel et al$.(2020).$

$2\mathrm{.}1\mathrm{.}1.$ Using entity modelling, define three separate $($not linked$)$ entities to graphically

illustrate the business rules. Add the underscore character followed by your student

number to each entity name. For example, TABLENAME$\_39475964.$

$(32)=(6)$

$(32)=(6)$

$2\mathrm{.}1\mathrm{.}2.$ Provide a brief description of the role of each entity.

$2\mathrm{.}1\mathrm{.}3.$ Using entity modelling, define primary keys $($PK$)$ and foreign keys $($FK$)$ for...

Entity $1$ ;

entity $2$; and the

the bridge entity

$(22)=(4)$