Implementing Database Schema using MYSQL queries
Description: This repository contains database schema using the existing ER diagram. SQL queries is used to create database schema to implement the relational database.Various queries are used in this schema like INSERT, CREATE, SELECT etc.. The schema here is intended for a MySQL database. In this database schema, I've created 5 tables using MYSQL queries and constraint is also implemented. Constraint is implemented using Null/Not Null. SQL INSERT queries are used to populate the schema.Firstly, a database for the ER diagram which is PAPERREVIEWS is created using CREATE query, and then the tables are created inside the database and each tables contains numbers of columns. INSERT query is used to insert the data into columns which is done to populate the database schema.
Synopsis: "create_tables.sql" will have database schema which creates tables, where data is populated into schema using INSERT queries.
Database Tables: I have created 5 tables implementing the ER diagram where there was Below is the overview on individial tables:
Author : It consists of information of the author. columns email addresses firstname last name
Reviewer: It consists information of reviewer. columns: -Emailaddress , it is a primary key. -FirstName -AuthorFeedback -LastName -CommiteeFeedback -Phonenum -Affiliation
Paper: It has information about papers written. columns: Id , it is a primary key. Abstract FileName
Topic: columns: Id , it is primary key Topicname
Review: It contains the information about the paper. Columns: Recommendation Id, it is primary key MeritSCore PaperID Readabilityscore ReviewId OriginalityScore RelevanceSCore