Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please convert the data in this crow's foot notation to tables using mssql code in the sql database.I need all of the mssql codes while

image text in transcribed

Please convert the data in this crow's foot notation to tables using mssql code in the sql database.I need all of the mssql codes while you will use for create table in the database.

Author PK Author ID Number First Name Text Last Name Text Address Contact Number Date of Birth Number Gender Text Language +PK Language Number ID Name Text Text Thesis Thesis PK Number number title Text abstract Text FK author Id Number Year Number type Text FK University ID Number FK insituted id Number no. of pages Number FK Languages id Number Submission Number date FK Supervisor ID Number FK Subject ID Type University PK University ID Number Name Text Address Contact Number Supervisor PK Supervisor ID Number First Name Text Last Name Text Address Text Contact Number Gender Text Text Institute OPK Institute ID Number OFK University ID Number 0 Name Text O Address Text Contact Number Subject PK Subject ID Number Name Text

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions

Question

Know the two most common approaches to appraisal timing

Answered: 1 week ago