Write and run scripts to create tables and define constraints.

computer science

Description

Part 1: Create Table diagram from ERD

- The database will have between 5 and 7 related entities.

Part 2: Write and run scripts to create tables and define constraints.

- All tables will have PK/FK defined

Part 3: Insert sample data

- At least 5 records should exist in each table.

Part 4: Test database

Part 5: Write questions and answer queries to exercise each one of the following concepts:

  • Sorting data and Restricting Rows (Ch 8)

  • Joining Data (Ch 9)

  • Single-row functions (Ch 10)

  • Group functions (Ch 11)

  • Subqueries (Ch 12)

Ask This Assignment To Be Done By Our Experts

Get instant assignment help service

Related Questions in computer science category