CS 415 Database Systems Modeling Introduction, Exams of Database Programming

Download CS 415 Database Systems Modeling Introduction and more Exams Database Programming in PDF only on Docsity!

Modeling Introduction

CS 115 Database Systems

Fall 2021

●

Given an understanding of the data (and/or

application the data will be used for)

• (^) Design a database schema that represents the data
• (^) Document the schema visually with ER Diagrams

Example

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept. NOUNS (entity sets or attributes) VERBS (relationships)

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept. Name of the database

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept.

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept.

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept.

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept.

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept.

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept.

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept.

JumboCash requires that we associate each student's ID card with a record containing the ID number and the amount of cash available. Students can load more cash on to their accounts at the bursar. A set of authorized vendors can draw from the account. An authorized vendor has a name , address , and phone number. When a student makes a purchase , their cash is deducted and the amount owed to the vendor is increased. Periodically, the authorized vendors are paid the amounts owed and a payment record is kept. (implies this relationship will have attributes)