This website uses cookies to ensure you have the best experience. Learn more

Sql Coding Essay

377 words - 2 pages

1. Write SQL code to create a STUDENT table that includes the following attributes:
• Student ID
• First Name
• Last Name
• Street Address
• City
• State
• Zip Code
• Phone
• Email
In the code remember to include data type, data size, and if that field is required or not. The selected data types and data size should be logical. For example you cannot use Char (10) for street address; size 10 is very small compared to many long street addresses that we deal with every day. Having a short size data will create error messages.
1. Create table STUDENT (
StudentID Number (1,1) not ...view middle of the document...


• Add a column called StudentStatus to the table above.
• Add a new constraint to limit the student zip code to be within the following group (32117, 32116, 32115, 32114)
• Count the number of rows in the table
• Show the first 3 records of data.
• Delete the column StudentStatus.
• Create a view that shows only First Name, Last Name, and Email
• View records of students living in area code 32116.
• Delete the table student

2.
1. Insert into STUDENT values (
‘1’, ‘Frank’, ‘Redman’, ‘18 RidgeWood ave’, ‘Ormond Beach’, ‘FL’, ‘32174’, ‘234-343-2134’, ‘RedmanF@gmail.com’);
2. Insert into STUDENT values (
'2', 'James', 'Richard', ’23 conqunia ridge way’, Ormond Beach’, ‘FL’, ‘23145’, '555-537-7654', 'Richard.James@somewhere.com');
3. Insert into STUDENT values (
'3', 'Frier', 'Liz', ’65 seaton valley’, ‘Palm Coast’, ‘FL’, ‘23342’, '555-537-6543', 'Liz.Frier@somewhere.com');
4. Alter table Student add column StudentStatus Char(20) not null;
5. Alter table STUDENT add
Constraints ZipCodeValuesCheck CHECK
(ZipCode IN (‘32117’, ‘32116’, ‘32115’, ‘32114’));
6. SELECT COUNT(*) AS NumberOfRecords
FROM STUDENT;
7. SELECT StudentID
FROM STUDENT
WHERE StudentID >=3;
8. Alter table STUDENT drop column StudentStatus;
9. Create view STUDENTVIEW as
Select FirstName, LastName, Email
From STUDENT;
10. Select *
From STUDENT
Where ZipCode = 32116;
11. Drop table STUDENT;

Other Papers Like Sql Coding

Unit 1 and Part of 2

1038 words - 5 pages Research Assignment 1. SQL It’s no surprise SQL (pronounced ‘sequel’) tops the job list since it can be found far and wide in various flavors. Database technologies such as MySQL, PostgreSQL and Microsoft SQL Server power big businesses, small businesses, hospitals, banks, universities. Indeed, just about every computer and person with access to technology eventually touches something SQL. For instance, all Android phones and iPhones have access

Human Resource, Policies Essay

652 words - 3 pages working closely with clients to integrate state-of-the-art web resources to improve revenue and meet other marketing goals • Responsibilities as an interface designer include analyze the requirements of the project and develop the coding with the help of the HTML, CSS, JavaScript/jQuery and XAML (Silverlight). • Played lead role in designing prototypes and GUI for Web Applications, Windows Applications and Handheld Applications • Visualize

Computer Tricks

3238 words - 13 pages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Minimizing Privileges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Implementing Consistent Coding Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Firewalling the SQL Server

Questions to Ask an Oracle Developer

1981 words - 8 pages did you do to work around it? When a table is in state of transition it is said to be mutating. eg: If a row has been deleted then the table is said to be mutating and no operations can be done on the table except select. • What’s your experience with Oracle Forms and Reports. Where would you implement bulk of business rules so as to make your coding more modular in Oracle Forms? PLL’s (PL/SQL Libraries). • What is referential integrity

Computer Network

2859 words - 12 pages . Dotdefender web application firewall can avoid many different threats to web applications because Dotdefender inspects HTTP traffic and checks their packets against rules such as to allow or deny protocols, ports, or IP addresses to stop web applications from being exploited. Architected as plug & play software, DotDefender provides optimal out-of the-box protection against DoS threats, Cross-Site Scripting, SQL Injection attacks, path traversal

Asignment

3234 words - 13 pages require coding techniques such as the use of SELECT FOR UPDATE. This issue should be considered when applications using serializable mode are ported to Oracle from other environments. Quiesce Database You can put the system into quiesced state. The system is in quiesced state if there are no active sessions, other than SYS and SYSTEM. An active session is defined as a session that is currently inside a transaction, a query, a fetch or a PL/SQL

Database Normalization

785 words - 4 pages The Five Normal Forms - formal definitions Introduction If your database design doesn’t conform to (at least) the 3rd Normal Form (3NF), chances are high that you will find it hard to achieve the performance need for a successful application. Furthermore, you will find that writing good SQL-statements (SELECT, UPDATE, INSERT or DELETE) will be difficult, and sometimes actually impossible without using a lot of procedural coding (PL/SQL in

Administartor

852 words - 4 pages ; | | | |Sites visits | | | |Agreed data format | | |Work schedule |Reviewed asset list and Agreed on Coding system

Online Job Portal

5491 words - 22 pages Speed : 1.80 GHz and above. RAM capacity : 256 MB and above. Hard Disk Space : 1 GB. Keyboard : Standard 104 key. Mouse : Optical. Display Type : 18’’ color monitor. 3.1.2 SOFTWARE REQUIREMENTS Operating system : Windows XP, 7. Coding Language : Asp.net, C#.net. Data Base : Microsoft SQL Server 2005. Design Tools : Rational Rose Enterprise Software. 3.2 FUNCTIONAL REQUIREMENTS The relationship between Input and Output to the

A Search Engine for Management Research in India

1134 words - 5 pages flow diagram 3. Tools i. Forms layout ii. Coding 4. Results 5. Conclusion 6. Reference INTRODUCTION A Search Engine is designed to search for information on the World Wide Web. The search results are usually presented in a list of results and are commonly called hits. The information may consist of web pages, images, information and other types of

First Essay

987 words - 4 pages | Operating Systems | Windows 98/XP/Windows7, LINUX | Database Tools | SQL Yog, MySql Query Browser. Toad | Certifications Completed Oracle Weblogic Essential Administration Certification in May 2014 Organization Details Organization Name | Location | Designation | From Date | To Date | Oracle India | Bengaluru, India | Technical Analyst | Feb 2014 | Till Date | Cross Country Infotech | Pune, India | Sr. Software Engineer | May 2013

Related Essays

Cursors In Pl/Sql Essay

3048 words - 13 pages SQL Cursor  A SQL cursor is a private Oracle SQL working area. There are two types of SQL cursor: implicit or explicit cursor. The implicit cursor is used by Oracle server to test and parse the SQL statements and the explicit cursors are declared by the programmers. Using the implicit cursor, we can test the outcome of SQL statements in PL/SQL. For example, • SQL%ROWCOUNT, return the number of rows affected; • SQL%FOUND, a BOOLEAN

Comparision Of Tools Essay

1209 words - 5 pages : When it comes to DB support, QTP demands for DSN (OBDC32 interface) and selenium demands for extensive coding but, TestingWhiz does not require any scripting. It offers database support through Oracle, MS SQL Server, IBM DB2, and MySQL. Access to Object Repository : Through selenium, it is not editable, whereas through other two i.e. QTP 10 and TestingWhiz, it is editable. In addition, object repository is re-usable through TestingWhiz. Test

Enterprice Architechture Essay

1264 words - 6 pages -side web code. The Visual Studio .NET IDE makes coding much, much easier. This also a Microsoft technology which we should purchase for the use of this technology. * PHP PHP is an open-source server-side scripting language. We can create dynamic web pages with the PHP scripting language. A dynamic Web page interacts with the user, so that each user visiting the page sees customized information. PHP can also be used to create dynamic web pages

Db Testing Essay

5118 words - 21 pages therefore have to rely on coding using their macro language anyway. As much as possible, I recommend bypassing their programming macro language and writing your tests in SQL script code directly in your RDBMS or using a variety of relatively simple scripting languages – VBScript, PERL, Ruby, Javascript. Why, you ask again? Because they’re more reusable and portable in terms of your database, of course, and also because the skill set for using these