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, ItemlID) 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.

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, ItemlID) 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.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section8.2: Lookup Tables And The Iferror Function

Problem 4QC

See similar textbooks

Similar questions

A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the second is the average fee for all condos in the CONDO_UNIT table thathave that square footage. Use AVERAGE_FEE as the column name for the average fee.Group and order the rows by square footage. a. Write and execute the CREATE VIEW command to create the CONDO_FEES view. b. Write and execute the command to retrieve the square footage and average fee foreach square footage for which the average fee is greater than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?
Change the CONTACT view so that no users can accidentally perform DML operations on the view.
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
LAB - Select horses with logical operators The Horse table has the following columns: • ID integer, primary key • RegisteredName - variable-length string • Breed - variable-length string • Height-decimal number • BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
Create the table Students (sno, sname, dateofbirth, program, cgpa) Fees (sno, date, fee ) Elective (sno, subcode, sub_name) Marks (sno, subcode, marks, grade) Subject ( subcode, subjectname, credit) Constraints (dateofbirth should be less than todays date in student table) (fee can not zero or negative in fee table) (Credits can not be zero or less in subject table) Query List the name of the student who got maximum cgpa. List the maximum, average and minimum CGPA for every program List the name of students who have choosed 4 credit subject List the total fee paid by every students
MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL Primary key is (HorseID, LessonDateTime) If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Notes: Table and column names are case sensitive in the auto-grader. Your SQL code does not display any results in Develop mode. Use Submit mode to test your code.
Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL Primary key is (HorseID, LessonDateTime) If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically.
True or False Rather than showing multiple rows at once, a Details view lets the user see one row at a time.
1- Create a NONGAME table with the following structure: Column Туpe Length Decimal Places Nulls Allowed? Description ITEM NUM CHAR Primary Key 4 No DESCRIPTION CHAR 30 ON HAND DECIMAL 4 CATEGORY CHAR 3 PRICE DECIMAL 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME. 3- In the NONGAME table, change the description of item number DL51 to "Classic Train Set". 4- In the NONGAME table, increase the price of each item in category TOY by two percent. (Hint: Multiply each price by 1.02). 5- Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95. 6- Delete every item in the NONGAME table for which the category is PZL. 7- In the NONGAME table, change the category for item FD11 to null. 8- Add a column named ON_HAND_VALUE to the NONGAME table. The on-hand value is a seven-digit…
Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_. For example, MGMT2006_G50_ Jane Doe