Question: Task 1. Create a database using PostgreSQL Consider a small university database with the following data. Students student idname (PK) date of birth address email





Task 1. Create a database using PostgreSQL Consider a small university database with the following data. Students student idname (PK) date of birth address email level (Not Null) Alice Wood 06/15/19935637 NW41STawood001@cis.fiu.edu ugrad Henrie Cage 04/24/19941443 NW7SThcage001@cis.fiu.edu ugrad John Smith 01/09/1995731 NW87 AVE jsmit005@cis.fiu.edu ugrad Franklin Wong 12/08/1995638 NW 104 AVfwong001@cis.fiu.edu ugrad Jennifer King 11/08/1998 3500 W Flagler ST jking001@cis.fiu.eduugrad Richard Young 12/05/1995 778 SW 87 AVE Tyoun001@cis.fiu.edu grad (Unique) (Not Null) 4 Robert Poore 08/22/1996 101 SW 8 ST Tpoor001@cis.fiu.edu grad Joyce English 07/31/1999 8421 SW 109 AV jeng1001@cis.fiu.edu grad Faculties date of birth address level faculty_idname (PK) email (Not Null) (Unique) Not Null) George Blunt 08/13/197911345 SW 56 STbluns@cis.fiu.eduInstructor
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
