<div>
rafrancisco,<br />
<br />
Is there a disadvantage if we added a nullable column vs a new table?<br />
<br />
Thanks.
</div>


rafrancisco,

Is there a disadvantage if we added a nullable column vs a new table?

Thanks.

<div>
I can't think of any disadvantage of having a nullable column in your CustomerTable. &nbsp;It's not going to take up space if the Citizenship is either American or Canadian.
</div>


I can't think of any disadvantage of having a nullable column in your CustomerTable.  It's not going to take up space if the Citizenship is either American or Canadian.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Please kindly assist how do we design a citizenship table?<br />
<br />
User will input his name and choose 1 citizenship<br />
-American<br />
-Canadian<br />
-Others &nbsp; (specify why)<br />
<br />
when user selects Others he/she need to input on why they choose that option (remarks).<br />
<br />
<br />
CustomerTable<br />
CustomerID<br />
CitizenID<br />
<br />
<br />
CitizenTable<br />
CitizenID<br />
CitizenShip<br />
<br />
How will we design the remarks table to link to CitizenTable? &nbsp;Not sure if we need to link to Citizen or we can link it straight to Customer table.<br />
<br />
Thanks.<br />

</div>
</div>


Hi,

Please kindly assist how do we design a citizenship table?

User will input his name and choose 1 citizenship
-American
-Canadian
-Others   (specify why)

when user selects Others he/she need to input on why they choose that option (remarks).


CustomerTable
CustomerID
CitizenID


CitizenTable
CitizenID
CitizenShip

How will we design the remarks table to link to CitizenTable?  Not sure if we need to link to Citizen or we can link it straight to Customer table.

Thanks.


Citizenship table design

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.