Develop a database for a fictitious small school for its management of student records

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:

Don't use plagiarized sources. Get Your Custom Essay on
Develop a database for a fictitious small school for its management of student records
Just from $13/Page
Order Essay
  1. Write business rules based on the given business description in an MS Word file named Item1.
  2. Draw a logical ERD that follows the business rules. Save the drawing in a jpg, png, docx, or pdf file. Name the file Item2.
  3. Map the logical ERD to relations by using the relational schema format. An example of a relation in relational schema format is:
    Student (StudentId, FirstName, LastName, MiddleInitial, AdvisorId)Use bold to indicate PK and italic to indicate FK. Use both bold and italic to indicate a field that is both PK and FK. Save the relational schema in an MS Word file named Item3.
  4. Complete physical design by writing T-SQL code to generate the database and tables. Save the SQL file with SQL file extension and named Item4.sql. This file must include all code to create the database with schema and tables in just one click to run. It must include the drop database line as shown in the book.
  5. Answer all six questions outlined in Section 8.8 of your textbook. Save all six SQL statements in one SQL file with the name of Item5.sql.
  6. Put all the above five files (do not combine files) in a zipped folder titled CaseStudy and attach it here.

Requirements: it doesn’t matter | C#

Essay Assign
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.

Free Revisions

All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.


A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.


Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.

Originality & Security

At Essay Assign, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.

24/7 Customer Support

Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

We work around the clock to see best customer experience.


Flexible Pricing

Our prices are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.


Admission help & Client-Writer Contact

When you need to elaborate something further to your writer, we provide that button.


Paper Submission

We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.


Customer Feedback

Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.