Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AT&T LTE 11:01 AM 43% . Instructions This week, you will develop a database for a fictitious small school for its management of student records.

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
AT&T LTE 11:01 AM 43% . Instructions This week, you will develop a database for a fictitious small school for its management of student records. You will also be required to write SQL statements to answer a few questions. Your instructor is the product owner. Post questions for approval before making any assumptions. The business description is outlined in Section 8.1 of your textbook. Your tasks include the following: 1. Write business rules based on the given 2. Draw a logical ERD that follows the business 3. Map the logical ERD to relations by using the business description. rules relational schema format. An example of a relation in relational schema format is: Student (Studentld, FirstName, LastName, Middlelnitial, Advisorld) The above relation name is Student. It has five fields. The primary key is Studentld. A foreign key is Advisorld. 4. Complete physical design by writing T-SQL code to generate the database and tables. 5. Answer all six questions outlined in Section 8.8 of your textbook. Provide a screenshot for the output of each question. Acceptable formats include jpg, .png, .docx, or .pdf 6. Put all above five items in a zipped folder titled CaseStudy and upload to the appropriate Dropbox folder

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

Step: 3

blur-text-image

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

Temporal Databases Research And Practice Lncs 1399

Authors: Opher Etzion ,Sushil Jajodia ,Suryanarayana Sripada

1st Edition

3540645195, 978-3540645191

More Books

Students also viewed these Databases questions