Assignment 6 Sql Concepts And Database Design.
Assignment 6 SQL Concepts and Database Design The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: • Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice (InvNumber, InvDate, EmpNumber, InvAmount, CustomerID) • InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity) • Product (ProductNumber, ProductDescription, ProductCost) • Department (DepartmentID, DepartmentDescription) • Job (JobID, JobDescription) • Customer (CustomerID, CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data dictionary that includes the following: 1. A description of the content for each field 2. The data type of each field 3. The format the data will be stored as in the field 4. The range of value for the field 5. A label, as required, if the attribute is a primary key or foreign key Note: An example is shown in Table 7.3 in chapter 7 of the textbook. 2. Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following: DATABASE DESIGN Date: Submitted by: Data Dictionary Table Name Attribute Name Contents Data Type Format Range Required PK or FK Employee EmpNumber Employee Number INTEGER #### 1-9999 Yes Primary Key EmpFirstName Employee First Name VARCHAR(20) #### NA Yes EmpLastName Employee Last Name VARCHAR(20) #### NA...
Read More What Is Interaction Design
Chapter 1: What is interaction design? Q1: Usability is broken down into _____ 4 goals 5 goals 6 goals 7 goals P20 Q2: Effectiveness refers to _____ how good a product is at doing what it is supposed to do. the way the product supports users in carrying out their tasks. the extent to which the product provides the right kind of functionally so that users can do what they need or want to do. how easy a system is to learn to use. P21 Q3: Efficiency refers to _____ how good a product is at doing what it is supposed to do. the way the product supports users in carrying out their tasks. protecting the user from dangerous conditions and undesirable situations. the extent to which the product provides the right kind of functionally so that users can do what they need or want to do. P21 Q4: Safety refers to _____ how good a product is at doing what it is supposed to do. protecting the user from dangerous conditions and undesirable situations the extent to which the product provides the right kind of functionally so that users can do what they need or want to do. how easy a product is to remember how to use, once learned. P21 Q5: Utility refers to _____ how good a product is at doing what it is supposed to do. the way the product supports users in carrying out their tasks. the extent to which the product provides the right kind of functionally so that users can do what they need or want to do. how easy a system is to learn to use. P22 Q6: Learnability refers to _____ the way the product supports users in carrying out their tasks. the extent to which the product provides the right...
Read More Vlsi Design Lab Manual1.
Vi INSTITUTE OF TECHNOLOGY VLSI DESIGN LAB MANUAL NAME: ……………………………………… SIXTH SEMESTER DEPT. OF ELECTRONICS AND COMMUNICATION ENGINEERING 2013-2014 EC 2357: VLSI DESIGN LAB ANNA UNIVERSITY SYLLABUS 1. Design Entry and simulation of combinational logic circuits (8 bit adders, 4 bit multipliers, address decoders, multiplexers), Test bench creation, functional verification, and concepts of concurrent and sequential execution to be highlighted. 2. Design Entry and simulation of sequential logic circuits (counters, PRBS generators, accumulators). Test bench creation, functional verification, and concepts of concurrent and sequential execution to be highlighted. 3. Synthesis, P&R and Post P&R simulation for all the blocks/codes developed in Expt. No. 1 and No. 2 given above. Concepts of FPGA floor plan, critical path, design gate count, I/O configuration and pin assignment to be taught in this experiment. 4. Generation of configuration/fuse files for all the blocks/codes developed as part of Expt.1. and Expt. 2. FPGA devices must be configured and hardware tested for the blocks/codes developed as part of Expt. 1. and Expt. 2. The correctness of the inputs and outputs for each of the blocks must be demonstrated at least on oscilloscopes (logic analyzer preferred). 5. Schematic Entry and SPICE simulation of MOS differential amplifier. Determination of gain, bandwidth, output impedance and CMRR. 6. Layout of a simple CMOS inverter, parasitic extraction and simulation. 7. Design of a 10 bit number controlled oscillator using standard cell approach, simulation followed by study of synthesis reports. 8. Automatic layout generation followed by post layout extraction and simulation of the circuit studied in Expt. No.7 Note 1. For Expt. 1 to 4 can be carried out using Altera (Quartus) / Xilinx (Alliance) / ACTEL (Libero) tools. Note 2. For expt. 5-8 introduce the student to basics of IC design. These have to be carried out using atleast 0.5u CMOS...
Read More Vlsi Design Lab Manual.
Vi INSTITUTE OF TECHNOLOGY VLSI DESIGN LAB MANUAL NAME: ……………………………………… SIXTH SEMESTER DEPT. OF ELECTRONICS AND COMMUNICATION ENGINEERING 2013-2014 EC 2357: VLSI DESIGN LAB ANNA UNIVERSITY SYLLABUS 1. Design Entry and simulation of combinational logic circuits (8 bit adders, 4 bit multipliers, address decoders, multiplexers), Test bench creation, functional verification, and concepts of concurrent and sequential execution to be highlighted. 2. Design Entry and simulation of sequential logic circuits (counters, PRBS generators, accumulators). Test bench creation, functional verification, and concepts of concurrent and sequential execution to be highlighted. 3. Synthesis, P&R and Post P&R simulation for all the blocks/codes developed in Expt. No. 1 and No. 2 given above. Concepts of FPGA floor plan, critical path, design gate count, I/O configuration and pin assignment to be taught in this experiment. 4. Generation of configuration/fuse files for all the blocks/codes developed as part of Expt.1. and Expt. 2. FPGA devices must be configured and hardware tested for the blocks/codes developed as part of Expt. 1. and Expt. 2. The correctness of the inputs and outputs for each of the blocks must be demonstrated at least on oscilloscopes (logic analyzer preferred). 5. Schematic Entry and SPICE simulation of MOS differential amplifier. Determination of gain, bandwidth, output impedance and CMRR. 6. Layout of a simple CMOS inverter, parasitic extraction and simulation. 7. Design of a 10 bit number controlled oscillator using standard cell approach, simulation followed by study of synthesis reports. 8. Automatic layout generation followed by post layout extraction and simulation of the circuit studied in Expt. No.7 Note 1. For Expt. 1 to 4 can be carried out using Altera (Quartus) / Xilinx (Alliance) / ACTEL (Libero) tools. Note 2. For expt. 5-8 introduce the student to basics of IC design. These have to be carried out using atleast 0.5u CMOS...
Read More Vehicle Alcohol Detection Based On Mcu And Design And.
In – vehicle Alcohol Detection Based on MCU and Design and Implementation of Safety Control System Chong Fang Fu, Liu Chan Wan, Xin Gang Xu, Yin Liang Zhou, Gang Gang Li Information Engineering, Nanchang Hangkong University, Jiangxi, NanChang, China fcfnc2006@126.com, 1172662844@qq.com, 772914916@qq.com, 272238861@qq.com, 1272371204@qq.com Keywords: Alcohol detector; Pressure sensor; Voice alarm; Expiration judgment; Vehicle; Abstract.This article describes an alcohol detection based on MCU low-power controller, the controller uses alcohol sensors, pressure sensors, voice alerts, such as vehicle alcohol detection and safety control system, the system can be divided into two parts, one part detection may be handheld, another for controlled part, installed in the car, so as to realize intelligent vehicle alcohol detection and safety control. Because the system has high sensitivity and low power features, it has a high practical value. 1. Primed words In recent years, the frequent traffic accidents caused by drunk driving, causing huge losses to the ourselves and others, so, the monitoring and management of drunk driving became an essential part, but by common monitoring methods, mainly the consciousness of drivers and traffic police’s sampling. On one hand, spent a great deal of effort is very inefficient ; on the other hand, the traffic accident caused by drunk driving are still high. While national in May last year of implementation of the new drink – driving penalties, but alcohol driving accidents have also occurred frequently. To this end, we have studied the circuit with alcohol detection and intelligent voice alarm system, effective for simple circuit. Simply put, that is, when the alcohol concentration in drivers exhaled gas up alcohol, voice prompting and forcing power car bus, so that Make it unable to start the car. This integrated design based on the design of social phenomena and the predecessor, after a discussion with the students and...
Read More