aluka Cisco www C ascol 47F Mostly cloudy m BLDS BSCBC Go MSS fanshaweonline.ca/d2l/le/content/1519224/viewContent/13776575/View Reflect in...

 

Transcribed Image Text:

aluka Cisco www C ascol 47F Mostly cloudy m BLDS BSCBC Go MSS fanshaweonline.ca/d2l/le/content/1519224/viewContent/13776575/View Reflect in ePortfolio O Search Download FANSHAWE Objectives Part 1: Create a Database Part Create tables within a Database Part : Manage permissions to tables, databases and system Part 4: Perform a backup and restore of a database Part 5: Submission files to Dropbox (Review before starting the test!) Note: Complete parts in order, as some parts are prerequisites for others. . Part 1: Create a Database 1. Create a Database named DA1- example: DA1-01234567. Create the database as described below: Location of MDF Files: C:\Data Location of LDF Files: C:\Log Set Auto growth of the data file to 25% Use defaults for other items 2. Using PowerPoint, collect the following screen captures: Required (reference Level 0 in rubric) for each screen capture, be sure to add the applicable heading in PowerPoint, include your database name with your student number Heading: Part 1-B-Include a screen as the auto growth. SF Heading: Part 1-A - Include a screen capture which shows your database created in SQL Management Studio. Part 2: Create tables within a Database 1. Create the following 2 tables within the database you created in Part 1: Table #1 - Table name: MarketData; with columns outlined below: Fanshawe College. All rights reserved A FANSHAWE INFO-1291: Test #2 Print o ID_MarketData; integer; Primary Key o FirstName; varchar(25); not null o LastName; varchar(25); not null o Email; varchar(50); not null o ID Location; integer; not null Table #2 - Table name: Locations; with columns outlined below: o ID_Location; integer; Primary Key o City; varchar(50); not null 2. Using Power Point, collect the following screen capture: Required (reference Level 0 in rubric) for each screen capture, be sure to add the applicable heading in PowerPoint, include your database name with your student number Heading: Part 2-A-Include a screen capture which shows your database design for Table 1 Heading: Part 2 - B-Include a screen capture which shows your database design for Table 2 e which shows your database and log file locations as well L Activity Details Page 2 of 4 Open with docReader INFO-1291: Test #2 a S SINS F Go TX + 8:37 PM 10/8/2023 4 aluka Cisco www C ascol 47F Mostly cloudy m BLDS BSCBC Go MSS fanshaweonline.ca/d2l/le/content/1519224/viewContent/13776575/View Reflect in ePortfolio O Search Download FANSHAWE Objectives Part 1: Create a Database Part Create tables within a Database Part : Manage permissions to tables, databases and system Part 4: Perform a backup and restore of a database Part 5: Submission files to Dropbox (Review before starting the test!) Note: Complete parts in order, as some parts are prerequisites for others. . Part 1: Create a Database 1. Create a Database named DA1- example: DA1-01234567. Create the database as described below: Location of MDF Files: C:\Data Location of LDF Files: C:\Log Set Auto growth of the data file to 25% Use defaults for other items 2. Using PowerPoint, collect the following screen captures: Required (reference Level 0 in rubric) for each screen capture, be sure to add the applicable heading in PowerPoint, include your database name with your student number Heading: Part 1-B-Include a screen as the auto growth. SF Heading: Part 1-A - Include a screen capture which shows your database created in SQL Management Studio. Part 2: Create tables within a Database 1. Create the following 2 tables within the database you created in Part 1: Table #1 - Table name: MarketData; with columns outlined below: Fanshawe College. All rights reserved A FANSHAWE INFO-1291: Test #2 Print o ID_MarketData; integer; Primary Key o FirstName; varchar(25); not null o LastName; varchar(25); not null o Email; varchar(50); not null o ID Location; integer; not null Table #2 - Table name: Locations; with columns outlined below: o ID_Location; integer; Primary Key o City; varchar(50); not null 2. Using Power Point, collect the following screen capture: Required (reference Level 0 in rubric) for each screen capture, be sure to add the applicable heading in PowerPoint, include your database name with your student number Heading: Part 2-A-Include a screen capture which shows your database design for Table 1 Heading: Part 2 - B-Include a screen capture which shows your database design for Table 2 e which shows your database and log file locations as well L Activity Details Page 2 of 4 Open with docReader INFO-1291: Test #2 a S SINS F Go TX + 8:37 PM 10/8/2023 4