Reference no: EM1327985
This must be done in SQL Server 2005.
In the first exercise, the Class field in the Part table should be a string of size 5, and not an int.
1- Write a statement that creates a table named Part, with an Id field as an int idendity primary key(PK), a SupplierId int field, a Description string field of size 25, a Count int field, a Class string field of size 5, and an inspection small date field. All fields cannot have a value of null, and the SupplierId field should be an FK that references the PK of a Supplier parent table.
2- Write a satement to add a check constraint to the above defined table, which guarantees that values entered in the inspection small date field are not older than today, meaning from now on. According to new requirements from your business analyst, an inspection can only be scheduled in the future.
3- Write a statement to add a check constraint to the above defined table, which guarantees that values entered in the Count field are never less than zero.
4- Write a statement to add a check constraint to the above defined table, which guarantees that values entered in the Class field can only be limited to the following strings: Open, Spec, and Priv.
5- Write a statement to create a view that selects all fields from the above table, except for both Id fields, in addition to the supplier name field of the Supplier table referenced in question 1. Note that the user is only interested in Parts that are not of class Priv. In other words, parts of class Priv should not be returned. Hint: A JOIN must be used to only return common rows.
|
Problems in networking is the lack of enforceable standards
: Both the engineering and the front office areas will use 100BaseT (twisted-pair Ethernet), how may you interconnect those two areas.
|
|
Methods for assuring non-discriminatory work environment
: What are the three commonly used methods for assuring a non-discriminatory work environment?
|
|
The appropriate erp
: The appropriate ERP - What enterprise resource planning (ERP) systems do your organization rely on
|
|
Democratic leadership style to address international issues
: How can you adapt the participative/democratic leadership style to address international, cultural, and ethical issues?
|
|
Write down a statement to create a view
: Write down a satement to add a check constraint to the above defined table that guarantees that values entered in the inspection small date field are not older than today, meaning from now on. According to new requirements from your business analys..
|
|
What managemnet control system might guillermo use
: What Managemnet control system might Guillermo use to help it achieve its organizational goals? Please list references. 300 Words
|
|
Explaining the aaffirmative, action, policies, job, terminat
: Are affirmative action plans necessary for social progress? Given that employment at will is the basic policy, how can employees then challenge a termination?
|
|
Advantages and disadvantages of erp
: Advantages and disadvantages of ERP - Enterprise Resource Planning has many advantages. What are some of the disadvantages?
|
|
Explaining self-awareness and self-concept
: How do self-awareness, self-concept, and emotional intelligence and worldview enable a leader to model the capacities or characteristics of servant leadership?
|