A company X has hired you to manage its database. Choose a subject and propose a database for the company X. Perform the following tasks under Microsoft SQL Server 2012 (If not specified, you can write TSQL scripts or show the SSMS snapshots). Database configuration 1. Create the database [Database Name] that contains the following: a. Two Filegroups (Filegroup 1 ] and [Filegroup 21. [Filegroup 1] is the primary filegroup. b. Two schemas called [Schema 1] and [Schema 2] C. Data files: One Data file [Data File 1] on the Primary Filegroup and two other files [Data File 2] and [Data File 3] on the [File Group 2] Filegroup with the following properties: · Path: D:\[Database Name]\ - Initial Size: 50MB
A company X has hired you to manage its database. Choose a subject and propose a database for the company X. Perform the following tasks under Microsoft SQL Server 2012 (If not specified, you can write TSQL scripts or show the SSMS snapshots). Database configuration 1. Create the database [Database Name] that contains the following: a. Two Filegroups (Filegroup 1 ] and [Filegroup 21. [Filegroup 1] is the primary filegroup. b. Two schemas called [Schema 1] and [Schema 2] C. Data files: One Data file [Data File 1] on the Primary Filegroup and two other files [Data File 2] and [Data File 3] on the [File Group 2] Filegroup with the following properties: · Path: D:\[Database Name]\ - Initial Size: 50MB
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 97C: The following tables provide a very small portion of the data that will be kept in the database....
Related questions
Question
![A company X has hired you to manage its database. Choose a subject and propose a database for
the company X.
Perform the following tasks under Microsoft SQL Server 2012 (If not specified, you can write
TSQL scripts or show the SSMS snapshots).
Database configuration
1. Create the database [Database Name] that contains the following:
a. Two FilegrQups (Filegroup 1 ] and [Filegroup 21. [Filegroup 1] is the primary
filegroup.
b. Two schemas called [Schema 1] and [Schema 2]
Data files: One Data file [Data File 1] on the Primary Filegroup and two other files
с.
[Data File 2] and [Data File 3] on the [File Group 2] Filegroup with the following
properties:
- Path: D:\[Database Name]\
· Initial Size: 50MB
• Maximum size: Unlimited
· File Growth: 10%
d. Log File:
· Path: D:\[Database Name]\[Log File Name]
· Initial size: 15MB
- Maximum size: Unlimited
· File Growth: 5MB
Note:
you
should rename the [Database Name], [Eilegroup 1], [Eilegreup 21, [Shema 1], [Schema
2], [Data File 1] , [Data File 2] , [Data File 3] and [Log File Name].](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F28c62a50-b61c-4edb-92b7-a1de068a0746%2F07b84e22-9b79-4994-b574-b0006556f05e%2Fj29tip_processed.jpeg&w=3840&q=75)
Transcribed Image Text:A company X has hired you to manage its database. Choose a subject and propose a database for
the company X.
Perform the following tasks under Microsoft SQL Server 2012 (If not specified, you can write
TSQL scripts or show the SSMS snapshots).
Database configuration
1. Create the database [Database Name] that contains the following:
a. Two FilegrQups (Filegroup 1 ] and [Filegroup 21. [Filegroup 1] is the primary
filegroup.
b. Two schemas called [Schema 1] and [Schema 2]
Data files: One Data file [Data File 1] on the Primary Filegroup and two other files
с.
[Data File 2] and [Data File 3] on the [File Group 2] Filegroup with the following
properties:
- Path: D:\[Database Name]\
· Initial Size: 50MB
• Maximum size: Unlimited
· File Growth: 10%
d. Log File:
· Path: D:\[Database Name]\[Log File Name]
· Initial size: 15MB
- Maximum size: Unlimited
· File Growth: 5MB
Note:
you
should rename the [Database Name], [Eilegroup 1], [Eilegreup 21, [Shema 1], [Schema
2], [Data File 1] , [Data File 2] , [Data File 3] and [Log File Name].
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning