Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

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

Current Trends In Database Technology Edbt 2006 Edbt 2006 Workshops Phd Datax Iidb Iiha Icsnw Qlqp Pim Parma And Reactivity On The Web Munich Germany March 2006 Revised Selected Papers Lncs 4254

Authors: Torsten Grust ,Hagen Hopfner ,Arantza Illarramendi ,Stefan Jablonski ,Marco Mesiti ,Sascha Muller ,Paula-Lavinia Patranjan ,Kai-Uwe Sattler ,Myra Spiliopoulou ,Jef Wijsen

2006th Edition

3540467882, 978-3540467885

More Books

Students also viewed these Databases questions