Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase. Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables. Insert twenty (20) into each table Take screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number). Obtain the ER diagram and save it in the above folder.

Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase. Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables. Insert twenty (20) into each table Take screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number). Obtain the ER diagram and save it in the above folder.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 4TD: Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be...

See similar textbooks

Similar questions

Database for small Business Assignment Create a Database Restaurant. Create the following tables and assign primary key. Grocery (ItemID, Itemname, Price, Qty, Totalprice) Menu (DishID, DishName, Price, ItemID) Create a form with menu view using both the tables. Use Item Id, item name, price from the Grocery table and Dish Id, Dish Name, Price from the Menu table. Give titles to both the Main form and sub form. Give a background image to the form. Insert at least 5 records in both the tables using the form.
a.) Create the database and table in MYSQL, PhpMyAdmin as shown below in the screenshot: Database Name: Library_YourID Table Name: Books Field / Column Name Datatype with size Constraint BookID Int Primary Key Author Varchar(50) Title Varchar(50) PublishedDate Date Note: Export the database in your Desktop folder.
Create the database and table in MYSQL, PhpMyAdmin as shown below in the screenshot: Database Name: Library YourlD Table Name: Books Field / Column Name Datatype with size Constraint BooklD Int Primary Key Author Varchar(50) Title Varchar(50) PublishedDate Date 160% 三 O目 O ITDB201 FINAL EXA.. Meeting now | O Type here to search 近
Task 3: The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields: DRIVER_ID CHAR(5) (Primary key) DRIVER_FIRST_NAME VARCHAR(20) DRIVER_LAST_NAME VARCHAR(20) DRIVER_DRIVING_LICENSE_ID VARCHAR(10) DRIVER_DRIVING_LICENSE_CHECKED BOOL DRIVER_RATING FLOAT SQL Database Test: Create a new table to store information on active drivers Test Query: SELECT * FROM ACTIVE_DRIVERS Expected Results: DRIVER_ID DRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING_LICENSE_ID DRIVER_DRIVING_LICENSE_CHECKED DRIVER_RATING 2001 Willie Butler 1874501 1 4.4 2002 Justin Howard 1953853 1 4.8 2003 Anthony Walker 1735487 1 3.5 Task 4: The Driver Relationship team wants to have quick…
Create a database named midLastname Add below tables and their respective fields. Provide proper names for the tables and attributes. Events (Event ID, Event Type, Venue Code, Event Name, Start Date, End Date) Customers (Customer ID, Customer Name, Customer Phone, Customer Email, Customer Address, Customer Payment Method) Event Reservation (Booking ID, Customer iD, Event ID, Event Date, Event Time, Date booking made, Booking Seat count) Show all the tables inside the database. • Add below information to each table and display the content of each table once all the records are saved on the table. 1002 1003 1004 1005 Event ID Event Type Venue Code Seminar Review Birthday Training FIR2 F3R21 F1R1 F3R21 Events Event Name TechiT Seminar LET Review Anna at 18 CSS Training Customers Start Date 2019/11/21 2019/12/12 2019/11/21 2019/11/21 End Date 2019/11/25 2019/12/23 2019/11/21 2019/11/25 Customer Address Pio Duran 09451387293hadapa@yahoo.com Sorsogon City Customer Phone Payment Method Cash…
Task 3: The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields: DRIVER_ID CHAR(5) (Primary key) DRIVER_FIRST_NAME VARCHAR(20) DRIVER_LAST_NAME VARCHAR(20) DRIVER_DRIVING_LICENSE_ID VARCHAR(10) DRIVER_DRIVING_LICENSE_CHECKED BOOL DRIVER_RATING DECIMAL(2,1)
Task 3: The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields: DRIVER_ID CHAR(5) (Primary key) DRIVER_FIRST_NAME VARCHAR(20) DRIVER_LAST_NAME VARCHAR(20) DRIVER_DRIVING_LICENSE_ID VARCHAR(10) DRIVER_DRIVING_LICENSE_CHECKED BOOL DRIVER_RATING FLOAT ANSWER IN MYSQL PLEASE
First Task: Create Database using PHPMyAdmin that includes two tables: 1. Order (OID, Price, and Date). 3. Product (PID, PType, Pname, OID). Note: Database name: purchasing Order and Product has 1to M relationship. OID and PID are primary keys. Insert 4 records to Order table and 4 records to Product table.
write the proper command to create all the tables with the relation between the tables. Assume the following scenario: Due to COVID-19 pandemic Your client has decided to design a database system to control the number of reservations on their resort mountain. The reservation system will take in consideration the following criteria. The maximum allocation based on the product type, take in consideration that the reservation type can be expanded in the future to more than these basic types. The reservation types are Tubing. Mountain. The Product Variant will store information such as the reservation type, the session that the product use such as: Session 1 Reservation. Session 2 Reservation. Session 3 Reservation. Session 3 in the Reservation require that both Session 1 and Session 2 to have availability in the system. The Maximum reservation limit depends on the minimum availability for the 3 Session in the system. Each day has its own reservation limit. Therefore, if the system…
To create a plugin, should one create new post types or new database tables?
1. The rows in the JOBS table store a minimum and maximum salary allowed for different JOB ID values. You are asked to write code to ensure that employees' salaries fall in the range allowed for their job type, for insert and update operations.
Harma ngs Review View Help he Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Solve the two questions given in the exercise (an induvial work). Recall the pharmacy system that we discussed previously. Draw two tables, one for patient and one for doctor. Include the required attributes (that we discussed) so that DOCTOR_ID is a foreign key in the patient table. Now, fill in both table with 6 records in each (any dummy data). Your task is to find out the following: Inner join Left join Right join For each join task, draw the output table. 1.