File with task description is uploaded below
Part 1 - Please produce a logical data model to satisfy the information stated above. Your model should include the following:
Table and column names structured using title case, no spaces or underscores, no special characters. Example: Students, Members, Staff, FirstName.
Table names should be plural and column names should be singular.
All tables should begin with a primary key using the integer data type and have the column name TableId. Example: StudentId, MemberId, StaffId. Notice the lower case d in Id.
Indicate which columns are primary and foreign keys by including the PK / FK notation.
Specify the data type for each column as well as the size if applicable, be sure to choose an appropriate size and data type based on MySQL.
Describe the relationships between the various tables using an appropriate notation that distinguishes between the various types of relationships.
There should not be any many-to-many relationships in your diagram; many-to-many relationships should be described using an intermediary table.
Include your full name, student number, and the title Case 1 visually on your diagram.
Part 2 - Write a minimum 500 words that includes each of the following:
Provide a summary description of your model and its overall purpose as it relates to the case.
Provide a list of five benefits (not features) that this model would bring to the YouTube channel's creator if your model was realized ad a fully functioning software application / database. Describe each benefit in a minimum of 50 words.
For each of the tables in your model:
Describe its purpose as it relates to the case.
Describe how it relates to the other tables.
4 freelancers are bidding on average ₹1100 for this job
hi I have total 5 years of experience in SQL Developer position and I have good knowledge on creating stored procedures and triggers and functions and indexes and performance tuning and query optimization and Views.