Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started