Skip to content

Latest commit

 

History

History
7 lines (7 loc) · 578 Bytes

Assign3.md

File metadata and controls

7 lines (7 loc) · 578 Bytes
Raw

Assignment 3

  1. Create and populate a university database that has departments, persons. Use faker to create at least 3000 persons. Persons must have a home address.
  2. Some persons are students. Students can optionally have one major (a reference to a department).
  3. Some persons are professors. They are affiliated with one department.
  4. Write a query that shows all students with a Texas home address.
  5. Submit the Python code that creates and populates the database.
  6. Leave the database in place so that the instructor and TA can verify its structure and contents