Please see attachment(s)

please see attachment for the approve topic 

Running head: DATABASE PROJECT
1

DATABASE PROJECT
6

Name of the database

The Pet Database

The Purpose of the database

Name of the database

The Pet Database

The Purpose of the database

When it comes to the purpose of a database, the consideration made is mainly the kind of data that need to be collected. A vet doctor may need to run a database that identifies the pets and their owners whenever they visit the clinic. The pet database will collect data on various aspects of the pets and their owners. The data collection details will include details such as pet type, color, age,

Pet ID

, owner email, phone number, location, and membership categories. An entity refers to a place, person, or other things about which data can be collected.

The database entities

The entities are the building blocks that of the database. For this design, the entity will only be two and will have various attributes as follows. The attributes used will help distinguish one pet from the other.

1. Pet [ pet type, age, color, pet ID]

2. Owner [

Owner ID

, email, phone number, location, membership]

It means that tables in the pet database will include:

i. PET table

ii. OWNER table

Due to the fact that there will be many pets that visit the clinic, the pet table will include numerous records of all types (rows) and their attributes, which will be represented by the columns the database holds. A table will look like shown below.

As was noted in the text, the primary function of a database is to enable the search through data and gather important information. The search process usually involves sifting through bunches of information and in the event that such items cannot be differentiated from the other, it means there is no way important information will be extracted (Connolly & Begg, 2015). The database tables should contain records, referred to as rows, which must be differentiated from each other as shown in the table above. On the other hand, identifying a particular column that is able to uniquely differentiate rows in the able is considered a key element. The attribute is commonly referred to as a primary key. In this database, the pet type is considered the primary key as the other two columns cannot be considered as unique identifiers.

The Question to be Processed by the Database

The data question that the database should be able to run is:

i. “

Phone

Number for Pet ID.”

The goal of the question is to enable the vet find the details of the owner of a particular pet. Already, all pets will have tags with IDs on them, hence the vet will only need to run the ID on the database, and find the details about the owner.

Users and Administrators

The vet will be the administrator, meaning he will have the central control of the database. He will be responsible for the creation of new tables depending on the changing needs of the organization. Also, the administrator will carry out different types of authorization in a bid to regulate which parts of the database, the users can have an access to. The authorization is important in ensuring key information is not accessed by the users. On the other hand, the vet’s assistants are considered the users. They will interact with the system without writing any programs. However, they can write requests that will be run by the database, and the required results provided.

How Information would be Recorded and Used without a Database

Without a database, the information can be collected through the use of spreadsheets where information is fed in the columns and rows. This information will be in a table format, and will identify the attributes of the pets, and the owner. However, it means that any searches will be done manually where the spreadsheet content is searched through to find the required information. This can be tiresome may sheets are created. On the other hand, the vet clinic can use traditional filing system where a large file will be used for creating tables detailing the attributes of the pets and the owner. Also, when such a system is used, the retrieval of information will be challenging.

The Relationships between Entities

The relationship between entities is one-to-many, which means that a single row in table A can be linked with multiple rows in table B, but a single row in B is only linked with a single row in A (Lemahieu, Seppe & Baesens, 2018). The diagram below indicates the relationships between the entities.

Pet ID

References

Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Upper Saddle River, New Jersey: Pearson Education, Inc.

Lemahieu, W., Seppe, B., & Baesens, B. (2018). Principles of Database Management. London, UK: Cambridge University Press.