1 / 2

DBM 294 Week 2 Individual Assignment Data Definition Language//tutorfortune.com

DBM 294 Week 2 Individual Assignment Data Definition Language//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-294-week-2-individual-assignment-data-definition-language<br><br>DBM 294 Week 2 Individual Assignment Data Definition Language<br><br> <br>Instructions:<br>Implement a database that matches the specifications developed in<br>your Week One individual assignment.<br>Submit a file containing the SQL code needed to perform the following<br>tasks:<br>u2022tCreate a database named DBM294_LastName where LastName is<br>replaced with your own last name.<br>u2022tCreate the tables you designed in week one within this database.<br>u2022tCreate the primary and foreign key constraints on those tables in<br>accordance with the original specification.<br>Your document should be a plain text file (not an MS Office document,<br>PDF, or similar), and it should contain nothing but the SQL code<br>needed to do the above. Make sure that executing your code will result<br>in the creation of the database, tables, and related constraints. This<br>means that you should test your code live against Microsoftu00ae SQL<br>Serveru00ae in the Toolwireu00ae environment.<br>Submit, in addition to the one above, a file containing screen shots<br>which show the database with the name visible, and the tables showing<br>all columns, primary and foreign keys.<br>You may use the GUI tools to perform the above tasks and then<br>generate the associated SQL scripts automatically, but again, you<br>should test the execution of those scripts before submitting them.<br>Do NOT add any data to your tables - that will come in subsequent<br>weeks.<br><br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-294-week-2-individual-assignment-data-definition-language<br>

hitnit
Download Presentation

DBM 294 Week 2 Individual Assignment Data Definition Language//tutorfortune.com

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBM 294 Week 2 Individual Assignment Data Definition Language//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/dbm-294-week-2-individual-assignment-data-definition- language D B M 2 9 4 We e k 2 I n d i v i d u a l A s s i g n me n t D a t a D e fi n i t i o n L a n g u a g e   I n s t r u c t i o n s : I mp l e me n t a d a t a b a s e t h a t ma t c h e s t h e s p e c i fi c a t i o n s d e v e l o p e d i n y o u r We e k O n e i n d i v i d u a l a s s i g n me n t . S u b mi t a fi l e c o n t a i n i n g t h e S Q L c o d e n e e d e d t o p e r f o r m t h e f o l l o w i n g t a s k s : C r e a t e a d a t a b a s e n a me d D B M2 9 4 _ L a s t N a me w h e r e L a s t N a me i s  r e p l a c e d w i t h y o u r o w n l a s t n a me . C r e a t e t h e t a b l e s y o u d e s i g n e d i n w e e k o n e w i t h i n t h i s d a t a b a s e . C r e a t e t h e p r i ma r y a n d f o r e i g n k e y c o n s t r a i n t s o n t h o s e t a b l e s i n   a c c o r d a n c e w i t h t h e o r i g i n a l s p e c i fi c a t i o n . Y o u r d o c u me n t s h o u l d b e a p l a i n t e x t fi l e ( n o t a n MS O ffi c e d o c u me n t , P D F , o r s i mi l a r ) , a n d i t s h o u l d c o n t a i n n o t h i n g b u t t h e S Q L c o d e n e e d e d t o d o t h e a b o v e . Ma k e s u r e t h a t e x e c u t i n g y o u r c o d e w i l l r e s u l t i n t h e c r e a t i o n o f t h e d a t a b a s e , t a b l e s , a n d r e l a t e d c o n s t r a i n t s . T h i s me a n s t h a t y o u s h o u l d t e s t y o u r c o d e l i v e a g a i n s t Mi c r o s o f t ® S Q L S e r v e r ® i n t h e T o o l w i r e ® e n v i r o n me n t . S u b mi t , i n a d d i t i o n t o t h e o n e a b o v e , a fi l e c o n t a i n i n g s c r e e n s h o t s

  2. w h i c h s h o w t h e d a t a b a s e w i t h t h e n a me v i s i b l e , a n d t h e t a b l e s s h o w i n g a l l c o l u mn s , p r i ma r y a n d f o r e i g n k e y s . Y o u ma y u s e t h e G U I t o o l s t o p e r f o r m t h e a b o v e t a s k s a n d t h e n g e n e r a t e t h e a s s o c i a t e d S Q L s c r i p t s a u t o ma t i c a l l y , b u t a g a i n , y o u s h o u l d t e s t t h e e x e c u t i o n o f t h o s e s c r i p t s b e f o r e s u b mi t t i n g t h e m. D o N O T a d d a n y d a t a t o y o u r t a b l e s - t h a t w i l l c o me i n s u b s e q u e n t w e e k s . Click on below link to buy https://tutorfortune.com/products/dbm-294-week-2-individual-assignment-data-definition- language

More Related