Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a database containing information about a topic or subject of your choice. Some suggestions include: Something you own or collect, such as music (CDs/albums/song

Create a database containing information about a topic or subject of your choice. Some suggestions include:

Something you own or collect, such as music (CDs/albums/song files), movies (DVDs/Blu-rays/video files)

2. The database must have at least three tables, and the table containing the main subject/theme item must have at least 15 rows. The others can have fewer rows. Each table should be related to one or more of the other tables.

There must be a way to connect or link the tables, although each table does not have to link directly to all the other tables. Each table should have its own unique/primary id.

3. Create at least four queries that answer questions about items in your database. At least two must join two or more tables . Use of the following concepts is required :

criteria

AND/OR logic

comparison (such as >, <, >=, <=)

a calculated or aggregated field

4. Create one form of your choosing .

5. Create one report of your choosing.

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

Main Memory Database Systems

Authors: Frans Faerber, Alfons Kemper, Per-Åke Alfons

1st Edition

1680833243, 978-1680833249

More Books

Students also viewed these Databases questions