Company analysis

 Company analysis 

Organizing information

Dividing Information into tables

 Age

Gender

 Race

 Form of Abuse

 Turning information into columns

 Sexual abuse

 Product ID

 Table relationship

					African American Latin Asian
	Sexual assault Incest Drug facilitated

What kinds of data will be in each table? What fields will contain these data?

The relational database stores and provides access to points of data which are related to each other. For instance, each table will include data about particular subject. In the above database each table includes raw and columns which contains different fields such as age, gender, and race. In addition, the table in relational database is related to data in other tables. For example, one table may have data that is linked to data in another table by a foreign key. The relationship between tables is what allows a data storage in a relational database in an organized and efficient way.

How will the tables be related to one another? What primary keys, foreign keys, or ID fields will you use?

The relational database has a structure that organizes data into different database tables. Tables are similar to folders in a file system, where each table stores a collection of information. The tables must be related to one another in some way for the relational database to work properly. Primary keys, foreign keys, and ID fields are all used to solve this problem. Primary keys are utilized to identify a row in a table. Foreign keys link data in one table to data in another table. The primary key is a unique value that identifies each row of data in a different table. The tables are inter-connected one on one, one too many, or many to many ways. The proper key is the most effective method for ensuring that a column's value and uniqueness are maintained. Furthermore, a relation in 1NF I it the value contained in it is atomic. In addition, a relation will be in 2NF if its in 1NF; and also, if the key attributes are dependent fully on the primary key. Finally, a relation will be in 3NF if it has no dependency in transitions and it’s in 2NF.

How will you normalize your data (1NF, 2NF, 3NF)?

The relational database 7th and 8th step is to apply the normalization rules which is to decompose relations with transitive dependencies into smaller relations; and also, if you're using a third-party data loader, check for functional and multivalued dependencies. For instance, the above diagram can decompose the relation “Likes” into two relations: one with attributes {user_id, food_type} and another with attributes {food_type, food_name}. We can also check for functional dependencies to see if there are any. For Instance, in the “Users” table, the functional dependencies are user_id -> age, gender, and race. In addition, in the “Likes” table, the functional dependency is food_type -> food_name. Finally, in the “Friends” table, the functional dependency is user_id1 -> user_id2. 

References

Link, S., & Prade, H. (2019). Relational database schema design for uncertain data. Information Systems, 84, 88-110.