In this assignment, we will study about the data normalization and data model in database.

computer science



In this assignment, we will study about the data normalization and data model in database. This will be fairly general to cover a lot of different situations. I'm trying to go with the idea that we're going to have a physical place where we're going to provide facilities (like a pet hotel) or act as a point of departure for service delivery. In cat’s hotel, a small luxury cattery that specializes in cats sleeping. The cattery is available to long and short stay throughout the year and is certified.

The newly constructed cattery is situated on the Orchard Farm property, but close to the center of Henley City. It has its own family room for better sanitation and an office could be mentioned in comfort with your cat / s requirements for your vacation. The building includes particulate filters and external security and safety sprinkler system.

Data Model

A data model is a conceptual framework that organizes information components and strictly enforces how they respond to each other and actual-world objects assets. For example, a data model that indicates that a cat's hotel information component is made up of a variety of other elements which, in effect, reflect the cat's cattery and size and identify its owner. We are all conscious of how the industry is evolving with innovation. Most of these professions are likely to be those that are not necessary for human contact. The data model stresses what research is required and how it should be structured rather than what procedures on the data should be done.

Name – The owner's name was given to his cat.

 SpeciesID – applies to the species dictionary which relates to the animal of animals.

 Birthday – If appropriate, the date of birth of the cat

Notes – Any additional notes in free text format applicable to this cat.

Pet- PetID, Name, SpeciesID, Birthday, Notes

Services- serviceID, ServiceName, OwnerID, cost, Limit, Room

Available_For- ID, ServiceID, SpeciesID, FaciltyID, Currently_used, CCTV_Access

In booking details table, attribute are BookingID, CatName, OwnerID, CatAge, RoomType, PayemntID.

Payment Details are available and their attribute PaymentID, ownerID, RoomType, ServiceID, Amount, faciltyID.

Room- RoomID, RoomType, catName, OwnerID

Food- FoodID, FoodName, OwnerID, RoomID, ID, PaymentID, PetID


Related Questions in computer science category

The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.