Relational Database Model: Design, Conceptual and Logical Model

Running head: RELATIONAL DATABASE MODEL
Relational Database Model
Name of the Student:
Name of the University:
Author Note

1
RELATIONAL DATABASE MODEL
Part 1: Research
The Relation database is the set of described tables and data in the tables which are
done formally for the resemblance of the data in various type of different procedures and
without having to re organize the whole dataset every time a data has to be recorded or
fetched from the database. Additionally, it is to be noted that the SQL or the Structured Query
Language is to be used as the Application programming Interface. The queries are used for
the interaction with the datasets that are used for retrieving the information from the
relational database for the collection of data for the reports and the forms according to the
requirement of the users.
In addition to the above information it is important the reader is informed about the
background of the relational database and its year origin. In the year 1970 the relational
database model was founded by a very young programmer named E.F Codd at IBM in his
paper. The relational database models are also known as the Large Shared Data Banks
according to Codd. The data are generally stored in the form of a hierarchy and navigational
structures are used for the organization of the data in the tables for the users. Each of the table
are called a relation in the relational database which contains a number of data categories in
the columns and these columns are also known as the attributes of the entities for which the
relational database are formed. Each of the row is either denote by a tuple or a record for the
data base. The unique instances of data in the table are known as the key of the table. It also
a unique primary key which can be denoted as the foreign key which can be used as a
reference of the other tables. There is also various type of relationships in between the table
of the data base, and this is where from which the relational database name comes into being.
An example of relational database is a typical business that would have data entry and
data fetching activities for their business process such an inventory management system

2
RELATIONAL DATABASE MODEL
which would be storing the data of the inventory such as the products of the system, the
orders to the warehouse of the system and the customers for the system. A customer table
would be containing the information about the name of the c customer, the address and
contact details of the customer. The table would also contain similar other tables.
Part 2: Design Database
The main entities considered for a family reunion are members and menu. Members
are family members and the menu is food items that would be cooked for the occasion.
Below is the design of the conceptual model of the family reunion.
The conceptual model is concise description of the requirements of the database,
which includes the detailed description of the entity, relationships and contains for the tables
that are involved in the database. It is also very useful in using the references so that the data
requirements of the users are met and do not conflict each other. It helps the designer of the
database in focusing on the data designs without any distraction on the storage and
implementation details. The attributes of the designed model above are MemberID,
MemberName, MemberAddress, MemberContact for Member and ItemID, ItemName,
Recipe and ingredients are the attributes of the entity Menu. The relationship is that many
member eats many menus.