A company X has hired you to manage its database. Choose a subject and propose a database forthe company X.Perform the following tasks under Microsoft SQL Server 2012 (If not specified, you can writeTSQL scripts or show the SSMS snapshots).Database configuration1. Create the database [Database Name] that contains the following:a. Two FilegrQups (Filegroup 1 ] and [Filegroup 21. [Filegroup 1] is the primaryfilegroup.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 followingproperties:- 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: 5MBNote:youshould rename the [Database Name], [Eilegroup 1], [Eilegreup 21, [Shema 1], [Schema2], [Data File 1] , [Data File 2] , [Data File 3] and [Log File Name].

Answered: Image /qna-images/answer/07b84e22-9b79-4994-b574-b0006556f05e.jpg

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 System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Given the relational database shop defined in the script below; create database shop;use shop; create table users( id int null auto_increment, firstname varchar(255), lastname varchar(255) not null, primary key (id)); create table items( id int null auto_increment, name varchar(255), price float, primary key (id)); create table orders( id int null auto_increment, id_users int not null, id_items int not null, primary key (id), foreign key (id_users) references users(id), foreign key (id_items) references items(id)); write three SQL queries to answer the following questions 1.- All products(items) in the shop catalog; product code, name and price 2.- Products sold in the shop; product code, name and price and full name of buyer. 3.- Products in stock (not sold); product code, name and price
1. What are the three stages during the startup of an Oracle database? If a copy of the control file is corrupted, which stage of the startup would fail? Briefly explains why. 2. What are the SQL statements to perform the following tasks? Create a smallfile tablespace Hw2Tbs that contains a 32MB datafile in the directory C:\app\abc\oradata\csc544744\myData Add another 8MB to tablespace Hw2Tbs
Consider the following PL/SQL script: SET SERVEROUTPUT ON BEGIN INSERT INTO COURSE (course_no, description, created_by, created-date, modified_by, modified_date) VALUES (course_no_seq.nextval, ‘database development’, USER, SYSDATE); COMMIT DBMS_OUTPUT.PUT_LINE (‘One course has been added’); END; Assumptions: All the COURSE table fields have check constraints defined on them indicating that none can be null. Explain why the script does not execute successfully. Add a user-defined exception to the script, so that the error generated by the INSERT statement is handled. Assign the code 2290 to this exception.
Which of the statements below is correct? a. Non-Oracle RDBMS use tablespaces as storage independent of database b. In Oracle, all users are given access to Tablespace. c. In Oracle, all instances use the same listener d. In Oracle, users who access the Database can all achieve the same results.
The following is necessary when multiple users access/modify the database simultaneously. A) Distributed database B) parallel database C) concurrency control D) centralized database Which one?
An objective of this task is to implement your own simple method of auditing the database activities.It is strongly recommended to connect to MySQL either through command line interface mysql or graphical user interface MySQL Workbench and process a script file dbdrop.sql and immediately after that the scripts dbcreate.sql and dbload.sql to refresh a sample database csit115.Download a file solution3.sql and insert into the file the implementations of the following actions.You must connect as a user root with a password csit115.Your implementation must directly follow a comment with a specification of a subtask.(1) First, the script makes a relational table that contains a general log empty.(2) Next, the script sets the appropriate values of the variables to save a general log in a relational table and to start recording a general log from now.(3) Next, the script makes a database csit115 a default database, it stops recording a report, it executes a script file updates.sql, and it…
Once a transaction is committed, it cannot be rolled back. True or false? An index file is always larger than the original database file because the index file needs to store an additional pointer to each record True or False?
I have been trying to get this program to work but every time I fix one area it throws 2 more codes, please show me what I am doing wrong, it is supposed to create a Database, with options to view all, add to, take away, update row, and view individual rows with a loop to repeat. _________ import sqlite3 #Define functions def CreateMemberDB(): conn=sqlite3.connect('Members.db') curs=conn.cursor() #create a table cmd_str=''' CREATE TABLE Member_Info( Name TEXT, Number INT, Phone NUMERIC )''' #send string to DB curs.execute(cmd_str) starting_data = ( ('Anna', 2435, 2345678910), ('Bryan', 2436, 3456789101), ('Claudia', 2437, 4567891012), ('Tom', 2438, 5678911234), ('Dusty', 2439, 6789112345) ) for row in starting_data: cmd_str= ''' INSERT INTO Member_Info(Name, Number, Phone) VALUES(?,?,?) ''' curs.execute(cmd_str, row) conn.commit() conn.close() def GetallMemberInfo(): conn=sqlite3.connect('Members.db') curs=conn.cursor() sql_cmd = 'SELECT ROWID, Name from Member_Info'…
demonstrate how to connect to a sqlite database. HOW TO SUBMIT YOUR ASSIGNMENT At the top of each of your C++ programs, you should have at least four lines of documentation: Program name (the C++ file name(s)), Author (your name), Date last updated, and Purpose (a brief description of what the program accomplishes). Here is an example: /* Program name: jbtictactoe.cpp* Author: John Doe* Date last updated: 5/1/2017* Purpose: Play the game of Tic-Tac-Toe*/ ASSIGNMENT: Database Connection Fact Database ER Diagram Write a program that opens a connection to the FACT database factdb.db Download factdb.db. If the connection doesn't open successfully print an error message from the database and end the program, otherwise print a success message. Then use a callback function to print the results of a select query (any select query of your choice) and close the database. To submit your assignment: Submit your source code file (*.cpp)
Use below command to build and load initial data to inventory collections.. There must be 8 documents in this collection. Run below command from command shell but show the result by taking screen shot from MongoDB Atlas You can use any of your existing database to build this collection under or simply write a command like use DBName to build a new Database and switch. then run below command to build collection. db.inventory.insertMany( [    { item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },    { item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "P" },    { item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },    { item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },    { item: "specialcard ", qty: 77, size: { h: 22.85, w: 30, uom: "cm" }, status: "A" },    { item: "christmascard ", qty: 65, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },    { item: "mothersdaycard", qty: 25, size:…
Use below command to build and load initial data to inventory collections.. There must be 8 documents in this collection. Run below command from command shell but show the result by taking screen shot from MongoDB Atlas You can use any of your existing database to build this collection under or simply write a command like use DBName to build a new Database and switch. then run below command to build collection. db.inventory.insertMany( [    { item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },    { item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "P" },    { item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },    { item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },    { item: "specialcard ", qty: 77, size: { h: 22.85, w: 30, uom: "cm" }, status: "A" },    { item: "christmascard ", qty: 65, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },    { item: "mothersdaycard", qty: 25, size: { h:…
Use below command to build and load initial data to inventory collections.. There must be 8 documents in this collection. Run below command from command shell but show the result by taking screen shot from MongoDB Atlas You can use any of your existing database to build this collection under or simply write a command like use DBName to build a new Database and switch. then run below command to build collection. db.inventory.insertMany( [    { item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" },    { item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "P" },    { item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" },    { item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },    { item: "specialcard ", qty: 77, size: { h: 22.85, w: 30, uom: "cm" }, status: "A" },    { item: "christmascard ", qty: 65, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" },    { item: "mothersdaycard", qty: 25, size:…