Create a new database user with SQL Server Management Studio named TinyCollege. Run the Ch02_TinyCollege_SQL. txt scripts (see the file link) to install the TinyCollege tables in your TinyCollege database. When you have created the TinyCollege tables in your database open the New Query window, type in the following and execute the T-SQL statement: use tinycollege; SELECT DB_NAME(database_id) AS "Database Name" , type_desc AS "File Type" , name AS "Logical File Name" , physical_name AS "Physical File" , state_desc AS "State" FROM sys. master_files WHERE database_id IN ( DB_ID('TinyCollege') ); Go Copy and paste the results into your assignment Word document. (10 points) Part 2 Answer the following using the figure below as your guide. Problem 1: Identify each relationship type and write all of the business rules. Problem 2: Create a basic Crow’s Foot ERD or Chen ERD for Tiny College.

Ihave a music player on my phone. i can buy songs, add them to playlists and play them. obviously it would be redundant to store each song in each playlist; each playlist is just a list of pointers to the songs. for this lab you will simulate this behavior. your program will need to have options to: add songs to the system library (you will store the text of the first line of the song, rather than the audio) add playlists add songs to a playlist list playlists play a playlist list all of the songs in the library with a count of how many times each song has been played remove a song from a playlist remove a playlist remove a song from the library (and thus from all playlists that contain it) note that we will not be checking many error cases. in real programming this would be bad, you should usually try to recognize and respond to as many types of errors as you can. in the context of class we are trying to acquaint you with as many concepts as possible, so for the sake of educational efficiency we will not be checking most errors in this lab, you may assume that your user provides correct input. you may add all appropriate error testing if you wish, but we will not be testing for it.

Why is an outfitting a workspace with video games in a technology development company considered a strategic use of money

What is the ooh? a. omaha occupation handbook b. online occupational c. occupations online d. occupational outlook handbook select the best answer from the choices provided