Create and edits screen through which you can edit

Assignment Help Database Management System
Reference no: EM131436851

1) Create a table named tbl_Security_Level with fields fld_Sch_Num_PK (autonumber is fine), fld_Sch_description (text 15).

2) Alter your existing tbl_Empoyees so that a FK field for the foreign is added (join compatible with the preceeding fld_Sch_Num_PK field).

3a) Using whatever tools you can lay hands on (php of course, but also Dreamweaver and etc.): create a splash screen that prompts for user id (and by query) selects landing screen.

At a minimum, create and "Edits" screen through which you can edit the underlying tables (would need highest clearance) and crucially, an order taking screen. My approach is to create queries that will be associated with each action.

Please have all screens but the first reflect back who is logged in. Also, all but first should have an escape button back to previous screen and all screens shoul have a logout button (upper right of screen).

Reference no: EM131436851

Questions Cloud

Draw a graph to represent the results : A one-way analysis of variance test was significant at the p = 0.009 level. Use MSE = 26.92 to find the Bonferroni 95% confidence intervals for all pairwise differences. Draw a graph to represent the results.
Design a lag compensator : Design a lag compensator D(s)=K(Ts+1)/( αTs+1), α
Design a backup and recovery strategy : Your friends Dinesh and Vinnie have started a small graphics design firm in Covington KY. They know you are enrolled in the MSIS program at UC and want you to design a backup strategy for them. Presently the firm is small, with only the owners Din..
If none of your graphs are perfect straight lines : If none of your graphs are perfect straight lines, what criteria will you use to choose the best one? Why must the [H3O+] and [CH3CH2OH] be much greater than the [HCrO !] in oxidation of ethanol by chromium (VI) experiment?
Create and edits screen through which you can edit : Create a table named tbl_Security_Level with fields fld_Sch_Num_PK (autonumber is fine), fld_Sch_description (text 15). Alter your existing tbl_Empoyees so that a FK field for the foreign is added (join compatible with the preceeding fld_Sch_Num_PK..
Find tukey confidence intervals for all pairwise differences : Use MSE = 0.0276 and the summary statistics below to find the Tukey 95% confidence intervals for all pairwise differences. Draw a graph to represent the results.
Did marwan commit sexual harassment if so what type : Did Marwan commit sexual harassment? If so, what type? Explain your answers and the terms you use. What is the legal nature of Marwan's employment? Explain your answers and the terms you use.
What is the molar mass of the gas : 1. If a 275-mL gas container has pressure of 732.6 mm Hg at -28 degrees C, how many moles of gas are in the container? 2. If the gas is condensed into a liquid, and the liquid weighs 1.95 g, what is the molar mass of the gas?
Conduct a one way analysis of variance test : Conduct a one-way analysis of variance test to determine whether there is an overall difference in population mean step heights. Use a = 0.05.

Reviews

Write a Review

Database Management System Questions & Answers

  Create a switchboard for your database

Do not use the Main Switchboard page that is provided for you, but rather create a new Switchboard named with your first name and the word Switchboard. (For example, mine is called Janis Switchboard.)

  Describe seperation between users and database administrator

describe seperation between users and database administrators

  Create an erd that represents the entities and attributes

Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.

  Define why is programming efficiency important

Taking into account the availability of today's powerful computers, why is programming efficiency important

  Write and execute a query whose passwords have expired

Write and execute a query that lists users whose passwords have expired or whole accounts are locked.

  Create three use case diagrams for the new billing

Using the Hillside School Case Study and your stage 1, 2, and 3 projects, develop a decision paper that serves as a system "sign-over" document for system deployment and transfer of responsibility for the newly designed and implemented system to t..

  Describe the main capabilities of mysql

describe the main capabilities of MySQL.

  What type of entertainment events are the most popular

What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years - Which area of venues used for organizing events is most popular in past 10 years?

  Create a query that will select records for customers

Create a query that will select customers who had less than 10 pounds of produce picked for Grapes, Watermelons, or Strawberries. The query should include the Service Date, Customer Number, Business Name, Street, City, State, Zip, and the Weight ..

  Discuss the costs involved in implementing the database

Using the SafeAssign link in Blackboard to submit your report. Download and print out the FULL report and attach to the appendix at the back of your report. Assignments without the full SafeAssign report will NOT be marked.

  Create a database design in visio the college has provided

After reviewing your database design from Lab 1: Creating a Database Design in Visio, the college has provided more information for the database that they want developed.

  Draw an entity relationship diagram for the system

Draw an Entity Relationship diagram for the system and Identify the table design for the database displaying all the fields/attributes. Ensure that all tables are in 3NF. You also need to identify the primary keys and foreign keys, where applicable..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd