3.+Designing

__**Designing Solutions: **__ (H2.2, H6.1, H6.2, H7.2)


 * __**A Data Flow Diagram (DFD) for searching for songs in the online store **__




 * __**An Entity Related Diagram (ERD) (This can be imported straight from Microsoft Access) **__


 * __**A description of at LEAST five queries used in the database (Three of these queries must involve relationships between tables in the database) **__

From the "Album" Table, list all Artist Names, TrackID and Album Release Year
 * 1. Query 1 (Simple Query using 'Query Wizard'- No relationship) **

Result:

List the Artist Name, Album Title, Release Year and Record Company Name of all those albums whose GenreID= 1 Query: 
 * 2. Query 2 (Relationship between three tables) **

Result:

List the GenreID, Artist Name and Album Release Year of all the albums with GenreName="Pop"
 * 3. Query 3 (Reationship between three tables) **

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Query:

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Result:

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">List the Artist Name, Album Title and the Record Company Name of all albums whose RecordLabelID= 303
 * <span style="color: #c65e06; font-family: 'Times New Roman',Times,serif; font-size: 120%;">4. Query 4 (Relationship between three tables) **

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Query:

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Result: <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">List the Album Title, Artist Name and Record Company Name of all Albums whose Tracks=12
 * <span style="color: #c65e06; font-family: 'Times New Roman',Times,serif; font-size: 120%;">5. Query 5 (Relationshiop between four tables) **

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Query:

<span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Results: <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">