Closed

Need someone who has knowledge in SQL data models and case -- 2

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.

Skills: SQL, MySQL, Database Administration, Database Programming, Microsoft SQL Server

See more: upload data csv file mysql, import excel sheet sql data base, source code export sql data csv file vb6, er diagram examples with solutions, entity relationship diagram example, er diagram practice problems with solutions pdf, entity relationship model, data modelling practice questions, er diagram examples with solutions in dbms pdf, entity relationship diagram exercises and answers, many-to-one relationship example, load data big file mysql, can export sql data excel, sample code sql data access data converting vbnet, uploading file mysql data uploaded, ssis package extract sql data text file, need pull data csv delimited text file, aspnet sql data file, vba sql data file forum, load data sql file mysql

About the Employer:
( 1 review ) St Louis, United States

Project ID: #27953056

4 freelancers are bidding on average ₹1100 for this job

Sarikahk

HI, I have 8 years of experience in working with data warehousing projects. Have work experience on SQL in databases like oracle, teradata, sql server

₹1500 INR in 7 days
(2 Reviews)
2.0
raviindia19

I have went through the project specifications and also videos of Techmoan to understand the project in more detail. As Techmoan work is more towards collecting the antique musical records and maintaining/studying th More

₹1450 INR in 3 days
(1 Review)
0.3
SpotContent

Hello Sir, I am a software engineer and a professional content writer geared up with 8 years of experience under numerous niches. My writing umbrellas articles, blogs, academic writing, case studies and much more. Bei More

₹600 INR in 1 day
(1 Review)
0.0
satishsql4321

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.

₹850 INR in 1 day
(0 Reviews)
0.0