subject

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.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 17:00
Aisha has finished working on a word processing document that contains 15 pages. she has added some special elements in the first three pages, page 9 and 10, and page 15 from the document. she wants to print only these pages to see how they look. which option is the correct way to represent (in the print dialog box) the pages that aisha wants to print
Answers: 3
question
Computers and Technology, 22.06.2019 22:00
Competent nonverbal communication involves interacting with others in a manner that is appropriate for which of the following? select all that apply. situation task individuals
Answers: 3
question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. what does it indicate when a website displays https instead of http? a. the website is secure. b. there is no secure sockets layer. c. the secure sockets layer is hidden. d. the website is not secure.
Answers: 1
question
Computers and Technology, 23.06.2019 22:00
Technician a says engine assemblies can be mounted longitudinally in a chassis. technician b says engine assemblies can be mounted transversely in a chassis. who is correct?
Answers: 2
You know the right answer?
Create a new database user with SQL Server Management Studio named TinyCollege. Run the Ch02_TinyCol...
Questions
question
Computers and Technology, 19.01.2022 04:10
Questions on the website: 13722367