Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Problem1. prepare the SQL code that will create ALL the tables as given in the appendix. Your answer should not contain the primary key and foreign key constraint declaration.  The data type for each attribute should be as specified in the Appendix. Assume that the tables will be associated with the dbo schema. The tables must be created on the Primary Filegroup and the table will NOT   make use of the IDENTITY feature to automatically increment the Primary Key value.

Problem2. Assuming that all the tables have been created as given in the relational schema in the Appendix, prepare SQL code to make the following changes in the structure of the tables. describe in which order the following constraint will have to be created so that the SQL Script does not generate any errors.

• Make the S_ID the Primary Key and the F_ID as the Foreign Key in the STUDENT table.

• Create a constraint in the STUDENT table for the S_CLASS column, so that it will only accept the following values: FR, JR, SR AND SO

• Make the F_ID the Primary Key and the LOC_ID as the Foreign Key in the FACULTY table.

• Create a constraint in the FACULTY table for the F_RANK column, so that it will only accept the following values: ASSO, ASST, FULL and INST

• Make the LOC_ID the Primary Key of the LOCATION table.

• Create a constraint for the F_PIN in FACULTY table, so that no two people will have the same PIN number.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M95825

Have any Question? 


Related Questions in DBMS

Design a relational database for a video rental store the

Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1,200 DVD titles. There are 25 supplier ...

List the different types of locks used by dbms systems and

List the different types of locks used by DBMS systems and explain how they differ from each other. Additionally, suggest the suitable scenario for each of them. 400 to 500 words, at least 4 references with one website r ...

Physical database design assignment query optimisationthis

Physical Database Design Assignment: Query Optimisation This assignment aims to develop your skills optimizing query. It involves identifying the suitable methods for structuring the data and writing the query. First, yo ...

Your assignment should be submitted in a single word doc

Your assignment should be submitted in a single Word doc (.doc or .docx). It should include your scenario diagram for Problem 1, and your Ruby source code for Problems 2 and 3. Contact me or post to our discussion board ...

Data mining is a powerful and tool but it poses challenges

Data mining is a powerful and tool, but it poses challenges to the protection of individual privacy. Data mining can combine information from many sources to create detailed profiles about each of us. Explore the Web sit ...

Realtor database data redundancy and anomaliesbullconduct

Realtor Database: Data Redundancy and Anomalies • Conduct an in-depth examination and analysis of the database, Realtor.accdb. Apply the concepts of database systems that you have learned this week. For example, you may ...

Db questions1 what is a consistent database state and how

DB QUESTIONS 1. What is a consistent database state, and how is it achieved? 2. List and discuss the five transaction properties. 3. What is a transaction log, and what is its function? 4. What is a deadlock, and how can ...

Database design and use group assignmentassignment

Database Design and Use Group Assignment Assignment Description - In this assignment you will use your normalized "City Jail" database you have created in your assignment one. You will form a group (2-3 students) and imp ...

Databaseplease read carefully and if u sure u can do it

Database Please read carefully, and if u sure u can do it email me., please Design a database (entity and relationship tables in Access) for a small college department library. You should have the entities and relationsh ...

Database systemretail store database Database system Retail Store Database: Relationships

Database system Retail Store Database: Relationships • Conduct an in-depth examination and analysis of the database, Week2_RetailStore.accdb . Apply the concepts of database systems that you have learned this week. For e ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate