Limited Time OfferFLAT 20% off & $20 bonus sign up. Order Now
New! Hire Essay Assignment Writer Online and Get Flat 20% Discount!!Order Now
Entity | Attribute Name | Description | Data Type and Length | Nulls | Multi-valued |
Customer | CustID | The unique value for identifying row | 4 Fixed character | No | No |
Name | The name of the customer | 20 Variable Character | No | No | |
Address | The address of the customer | 30 Variable Character | No | No | |
Contact | The contact number of the customer | 10 Variable Character | No | No |
Entity | Attribute Name | Description | Data Type and Length | Nulls | Multi-valued |
Ticket | TicketNo | The unique value for identifying row | 4 Fixed character | No | No |
IssueDate | The date of car parking entry | 20 Variable Character | No | No | |
IssueTime | The time of car parking entry | 30 Variable Character | No | No | |
IssueMachine | Machine from which the ticket was issued | 10 Variable Character | No | No |
Entity | Attribute Name | Description | Data Type and Length | Nulls | Multi-valued |
Parking Spaces | Space Number | The unique number for defining all the rows | 4 Fixed character | No | No |
SpaceQuantity | The total amount of space available | 4 Fixed character | No | No | |
OccupiedSpace | The total used space currently | 20 Variable Character | No | No | |
LeftSpace | Total remaining space | 30 Variable Character | No | No | |
Isfull | The car parking space is full | 2 Fixed Character | No | No |
Entity | Attribute Name | Description | Data Type and Length | Nulls | Multi-valued |
Tariff | TariffCode | The unique value for identifying row | 4 Fixed character | No | No |
StartTime | The date of car parking entry | 20 Variable Character | No | No | |
EndTime | The time of car parking entry | 30 Variable Character | No | No |
Entity | Attribute Name | Description | Data Type and Length | Nulls | Multi-valued |
Fault | FaultID | The unique value for identifying row | 4 Fixed character | No | No |
Date | The date of fault occurrence | 20 Variable Character | No | No | |
Time | The time of fault occurrence | 30 Variable Character | No | No | |
Description | The equipment name and description of the fault | 255 Variable Character | No | No |
Entity | Attribute Name | Description |
Customer | CustID | The unique value for identifying row |
Name | The name of the customer | |
Address | The address of the customer | |
Contact | The contact number of the customer |
Entity | Attribute Name | Description | Data Type and Length |
Ticket | TicketNo | The unique value for identifying row | 4 Fixed character |
CustID | The primary key of customer entity | 4 Fixed character | |
IssueDate | The date of car parking entry | 20 Variable Character | |
IssueTime | The time of car parking entry | 30 Variable Character | |
IssueMachine | Machine from which the ticket was issued | 10 Variable Character | |
| Type | There are three types of season ticket holder | 10 Variable Character |
| StartMonth | The starting month of the season ticket | 10 Variable Character |
| EndMonth | It is the ticket validity ending month. It is a derived attribute | 10 Variable Character |
| SpaceNumber | The space number of the parking which is allocated to the season ticket | 4 Variable Character |
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management. Cengage Learning.
Hernandez, M.J., 2013. Database design for mere mortals: a hands-on guide to relational database design. Pearson Education.
McCreary, D. and Kelly, A., 2014. Making sense of NoSQL. Shelter Island: Manning, pp.19-20.
Yin, R.K., 2013. Case study research: Design and methods. Sage publications.
No matter how close the deadline is, you will find quick solutions for your urgent assignments.
All assessments are written by experts based on research and credible sources. It also quality-approved by editors and proofreaders.
Our team consists of writers and PhD scholars with profound knowledge in their subject of study and deliver A+ quality solution.
We offer academic help services for a wide array of subjects.
We care about our students and guarantee the best price in the market to help them avail top academic services that fit any budget.
15,000+ happy customers and counting!