Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MIS 2113 OU Housing and Food Services asked you to help build a database to understand and track students and housing options across the university

image text in transcribed
MIS 2113 OU Housing and Food Services asked you to help build a database to understand and track students and housing options across the university system. You are asked to track students (name, address, age, and email address), dorms (name, address, number, type, and all amenities), and campus (name, address, and phone number). You determine that a student may live in many dorms and that a dorm may house many students. Each dorm will reside on a single campus and each campus will have multiple dorms. Additionally, you determine you want to know the semester and year a student stays in a dorm. Draw your complete diagram below the line. Ensure you follow ERD Rules. 14. ( 30 Points)

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

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

2nd Edition

1597499471, 978-1597499477

More Books

Students also viewed these Databases questions

Question

Sketch the waveform of a simple sound.

Answered: 1 week ago

Question

1. What are the major sources of stress in your life?

Answered: 1 week ago

Question

What tools might be helpful?

Answered: 1 week ago