Database Report: AutoSeller Database Design and Implementation

This report details the design and implementation of the AutoSeller database. The database utilizes a relational model and is built on MySQL. The structure includes tables for buyers, cars, sellers, car owners, and sales invoices. The report explains the rationale behind the table structures and their relationships, highlighting the use of primary and foreign keys. It discusses the choice of MySQL as a database management system, citing its ease of use and management compared to other systems like Oracle and MS SQL. The report emphasizes the efficient handling of data types and the straightforward creation of DML and DDL. The sales invoice table is identified as a crucial bridge, connecting buyers, sellers, and car information. The report also provides bibliographic references supporting the concepts discussed.

Running head: DATABASE
Database
Name of the Student
Name of the University
Author’s note:

1DATABASE
The database tables has been used as the database structure of the developed database
model. The structure of the database offers easy to organization of data. The database tables has
row and columns. The row refers to data for a particular entity such as customer, buyer, seller or
car sale. Therefore, the rows can be considered as records. These records can be defined as entity
or object. The columns refers to a specific type of data such as primary key, foreign key, dates of
purchase, ownership dates and more. That is why the columns are known as fields. The database
structure of AutoSeller can be considered as two dimensional array. A particular index is used
for identifying each individual value. Therefore, the tables of AutoSeller database can be
considered as the collection of records. The relational database model approach has been used
for implementing the database of AutoSeller.
Total five tables has been created in the database. Each table consist of data regarding
one real life aspect of business. The first table is buyer. The buyer is the person who buys the
cars through the organization. The second table is car. This table refers to the cars that are being
sold by the buyers. The information of seller is as important as the other two because, the seller
is the one who sells the cars. The car owner table holds the information of current car owners
who have made purchases from the seller through the organization only. If any other
organization is used for buying or selling car then those information will not be available in the
database. The sales invoice table is the one which stores all the operation related data. The sale
of car, the selling price and other sales related data are also stored in this table. This table also act
as the bridge table that connects the buyer, seller and car tables.
The MySQL platform has been used for developing the database. MySQL is an open
source database management system. MySQL is easy to use and manage. The connection to the
MySQL server is also very easy. The issues while connecting to the server is less than that of

2DATABASE
Oracle and MS SQL. MySQL database allows easy to develop DML and DDL that can allow
creating database structure easily. Unlike the Oracle, MySQL does not need to defined auto
increment separately. The dates can be stored easily by just defining date data type properly.

3DATABASE
Bibliography:
Laudon, K. C., & Laudon, J. P. (2016). Management information system. Pearson Education
India.
Zheng, Y., & Bai, Q. (2018, February). Design and Implementation of Database Centralized
Access Control and Audit System. In 2018 International Conference on Computer
Science, Electronics and Communication Engineering (CSECE 2018). Atlantis Press.