[SOLVED] Quiz/Hw 13  A General Database CRUD App

30.00 $

Programming resource
, Digital learning resource
Categories: ,
Practical programming resource
Suitable for guided study and reference
Tutor guidance available when needed

Description

5/5 - (2 votes)

Motivation:

To reinforce & test the knowledge you’ve learned for developing a web-database CRUD app.

Tasks 1. Add a table named customer to your database, with the following fields—properties:

a. custID—int, key, auto increment

b. custLastName: varchar(max)

c. custFirstName: varchar(max)

d. custNumKids: int

e. custNumPets: int

f. custBirthDate: date

g. custDateJoined: date, default: GETDATE()

 

2. Create the CRUD scripts (similar to last week), but named: cust-create.*, cust-retrieve.*, cust-update.*, cust-delete.*

3. Create a file named quizhw13.aspx, that has four links to your CRUD .aspx files from Task 2 (TWO GRADES OFF FOR NOT PROVIDING THIS FILE).

Resource details

Understand the Task Before You Use the Resource

Review the requirements, identify the programming concepts involved, study the implementation and test your understanding with your own examples and modifications.